|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 24th, 2009, 05:52 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
Table design
I have two fields, Birthdate and Age, how would i get the age to fill in
automatically from the birthdate field and if possible update automatically with the current date? 
|
|
#2
February 24th, 2009, 07:04 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Table design
Ditch the Age field. Any time that you need to know someone's age, you can
calculate it from the Birthdate field. Then you don't need to worry about updating the Age. For that I highly recommend Allen Browne's Age function available at: http://allenbrowne.com/func-08.html -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Pete" wrote: I have two fields, Birthdate and Age, how would i get the age to fill in automatically from the birthdate field and if possible update automatically with the current date?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
