Age Difference Date/Time Field
- From: "Fred" <fred@xxxxxxxxxxxxx>
- Date: Sun, 14 Jan 2007 16:12:54 +1100
First time doing this so if this is a ridiculous question my apologies.
Is it possible to fill the field Age field automatically and/or on Merge to
a Word document using a macro?
Table: Contacts
Birthday Date/Time
Age DateTime update each year on output according to Macro?
Where does one put the code for Age field to generate the current Age field
automatically if one can based on the date in Birthday field.
If I merge AGE I expect it to put 32 if person's BIRTHDAY field was 32 years
ago? Can I put a macro in the field?
Age:
DateDiff("yyyy",[Birthday],Now())+Int(Format(Now(),"mmdd")<Format([Birthday],"mmdd"))
I want the field to calculate age. I can achieve it in a report but can I
apply it to a field?
Many thanks.
.
- Follow-Ups:
- Re: Age Difference Date/Time Field
- From: John Vinson
- Re: Age Difference Date/Time Field
- Prev by Date: Re: Type in one field to bring up second field in Access 2002
- Next by Date: Re: Age Difference Date/Time Field
- Previous by thread: Re: Type in one field to bring up second field in Access 2002
- Next by thread: Re: Age Difference Date/Time Field
- Index(es):