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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 | |
|
|