Problem with birthdate calculation.

  • Thread starter Thread starter Rusty
  • Start date Start date
R

Rusty

I took a existing database and chanded the birthdate and age feild to
automatically calculate the age with ControlSource propeperty in the
form view. Now the age doesnt show up in the Table view.

The ages are being calculated in the form but do not change in the
table.

Help !

Rusty
 
I took a existing database and chanded the birthdate and age feild to
automatically calculate the age with ControlSource propeperty in the
form view. Now the age doesnt show up in the Table view.

The ages are being calculated in the form but do not change in the
table.
Click to expand...

This is EXACTLY HOW IT SHOULD BE.

If you store the Age field in the table you can guarantee that in 366
days *every single record in the table will contain incorrect data*.

Just calculate the Age as needed, on the fly, in a Query or on the
form or report. It need not and *should not* be stored in the table at
all.
 
Back
Top