update date fields automatically

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a date field used for birthdays, then I have another field used to
calculate the age using visual basic.
How can I get the birthday date to automatically update everytime I open the
database?
 
Do not store the Age field.

A person's date of birth does not normally change during their lifetime, so
there is no need to update this field. If you use a calcuation to derive the
age instead of storing it anywhere, you never have to update any fields in
the table.

There's an example of how to derive the age from the date of birth in this
link:
http://allenbrowne.com/func-08.html
 
Back
Top