Truncate Function 3

[BradW]

Good morning,

I am trying to create a calculated control that uses a truncate function. I don't want my answer to round up/down, simply drop the decimal. (I am calculating an age in years based on the current date at the time of entry now() and the DOB field). It works just fine, EXCEPT that it rounds up if the person is more than 1/2 way past the middle of the current year of age. I have used the truncate function in many other programs, but can not find an acceptable version in Access XP (using a database in Access 2000 format). Please help, I have tried truncate(), trunc() to no avail. Thanks in advance for your assistance.

 

[chrissie1]

try int() it converts it to an integer wich hase no decimals and doesnt round up or down.

 

[mwolf00]

If the INT() function doesn't work, I believe that there is also a function FIX() that truncates your number. Get the Best Answers! faq333-2924
Merry Christmas!
mikewolf@tst-us.com
[santa2]

 

[BradW]

Thanks to both for the help, Int() worked like a charm. I appreciate the quick and helpful assistance. Have a great weekend and New Year.