need some basic help please

[babydave]

Hi im desperate for some help with access and would be grateful if anyone can help.

I have a table with member information such as ID, postcodde, phone number and date of birth, what i want is for the age to be calculated automatically, how would i do that?

thanks.

 

[ssoltic]

Age you dont need in table. Lets query do calculation (on one field put this Age: Now()-[Day of Birth]). If you still need Age in Table create update query with this formula

 

[Mile-O]

Look for Pat Hartman's Useful Date Functions in the Sample Databases Forum