Age Difference Date/Time Field

[Fred]

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?

Posted in TablesDesign but thought Public.Access might be better.

Many thanks.

 

[Guest]

Hi Fred,

If you are attempting to store the results of an age calculation, you
shouldn't do this. It is always better to calculate it on-the-fly. It would
be best to delete the Age field from your Contacts table.



Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________