A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Change value to an integer on a form



 
 
Thread Tools Display Modes
  #1  
Old February 20th, 2007, 01:51 AM posted to microsoft.public.access.reports
crazyj0202
external usenet poster
 
Posts: 2
Default Change value to an integer on a form

Sorry, the name was supposed to be change value to an integer on a report
(not a form)

crazyj0202 wrote:
I have a form that has detailed human resource info. I have a field that is
in increments of .25. The sum can be x.00, x.25, x.50,and x.75. (x bring
any number) Unless the increments =1 I do not want it to sum on a particular
field on a report.

All I want is to always change the number to an integer (round down). I.e,
if the sum on the report is 4.25, 4.50 or 4.75 I want another field to take
that number and round down to 4. I hope this can be done.

I still want the 4.25 to show on the report, but just another box that was
created just for the purpose of putting that number or whatever number
rounded down to the whole number.

(FYI the source of the textbox is =sum[sumofsar], I thought that if I put dim
text86 as integer on form open and then I copied the same =sum[sumofsar],
into the source that it would work but it did not)

Thanks


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:45 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.