I have been asked to include an age on the form for residents in a residential home. I can get a query to round to the nearest integer, but i cannot get access to round down.
This is the field i am using which gives answer to nearest integer.
datediff: round((Date()-([date 1]))/365)

Please can someone help as i cannot think of many other ways of doing it.

datediff: ((Date()-[date 1])-((Date()-[date 1])/365))/365
gives a real number eg. 39.8.....

I am using access2000.

This site will show you 3 different ways that you can calculate age...

http://www.mvps.org/access/datetime/date0001.htm

I would like to thank you very much for the link to "the access web" site. It was very helpful and solved my problem. Thank you again.

Samulayo