Computing Ages Using Access 2000

  • Thread starter Thread starter Mark Watlock
  • Start date Start date
M

Mark Watlock

age: (Now()-[birth date])/365
Entering this expression in to a query returns the corrent
answer with 2 decimal places. By changing the decimal
places to 0 and format fixed rounds the number of years
up. How can we return an "unrounded" number to display
the persons correct age.

Thank you in advance.
 
See Doug Steele's
(http://members.rogers.com/douglas.j.steele/Diff2Dates.html) site for
a good function.

Another, shorter one that gives age only is available on Allen Brown's
site (http://allenbrowne.com/func-08.html)

--
HTH

Dale Fye


age: (Now()-[birth date])/365
Entering this expression in to a query returns the corrent
answer with 2 decimal places. By changing the decimal
places to 0 and format fixed rounds the number of years
up. How can we return an "unrounded" number to display
the persons correct age.

Thank you in advance.
 
Plse give an example of "unrounded" number considering that you already got
the "correct" (not quite, actually) answer with 2 decimal places.
 
Back
Top