Rounding Down

  • Thread starter Thread starter Richardson
  • Start date Start date
R

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
 
Back
Top