use query to find age

[Guest]

i have a database and need to use a criteria to calculate the age for all the
fields already in the table/database, does anybody know what code i should
use?
many thanks

 

[Svein Ludvigsen]

i have a database and need to use a criteria to calculate the age for all
the
fields already in the table/database, does anybody know what code i should
use?
many thanks

Try
Age: DateDiff("yyyy";[Born];Date())

Svein

 

[Guest]

unless there is a time stamp for the record or each field,
there is no way that you can calculate the age of the
fields. if there is a time stamp then in the query header
put
AGEate()-[TimeStamp]