| | |
|
|
|
Problem with birthdate calculation. |
|---|
| message from Rusty on 26 May 2004 |
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
|
| John Vinson replied to Rusty on 26 May 2004 |
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.
John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
|
|
Archived message: Problem with birthdate calculation. (Microsoft Access Database)
