View Full Version : Drop the Remainder


MEDolin
12-11-2001, 11:36 AM
I have a vaule that calculates to 218.50. In my report I only want to show whole dollars. I've been trying to use the format function, but have had no luck, it always rounds the number up to 219.

[Text1]=218.50, I want to display 218.

Any help would be appreciated!

pdx_man
12-11-2001, 12:42 PM
Use the INT() function

Pat Hartman
12-11-2001, 06:50 PM
You should also look up the "\" operator and see how it differs from the "/" operator.

MEDolin
12-12-2001, 05:14 AM
The INT function worked great. Thanks so much.