Rounding Down

[Richardson]

In a query I have a calculated field using Date() and my field, dateofbirth,
to calculate age. However, Access is taking control on the rounding and
making some people older than they want to be. None of the functions I know
will force it to round down to the nearest whole number. There is another
query where I want it to round up to the next whole number.
Any help you can provide will be appreciated.
Lori

 

[John Viescas]

See http://www.mvps.org/access/datetime/date0001.htm for two suggestions
about how to correctly calculate age from current date and date of birth.

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
http://www.deanforamerica.com/site/TR?pg=personal&fr_id=1090&px=1434411