Calcluating Age in a query 1

[gRegulator]

Hi,

How would I go about calculating length of time in a query. For example. I have a table called tbl_main, with field 'Date of Birth". How would I be able to use a query to calculate how old a person is? Thanks for any help!

 

[PHV]

Quick and dirty, in the query grid:
Age: (Date()-[Date of Birth])\365.25

Or:
Age: Int((Date()-[Date of Birth])/365.25)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[gRegulator]

PHV,

Thanks so much for your fast and useful response. Worked like a charm!

Greg