Age field questions

[vX987]

Hi. I am trying to create an AGE field for my database, but I'm not quite sure as how to have it update automatically once I input a date into my BIRTHDAY field.

I need age to be a field in my tables because I plan on using it in queries. I use to have it just in my forms and changed the control source to =DateDiff("yyyy",[Birthday],Now())+Int(Format(Now(),"mmdd")<Format([Birthday],"mmdd")) but with that, I would not be able to query it.

Got an idea? Thanks in advance!

 

[Brianwarnock]

Always calculate age when needed, never store it. Just calculate it in the query and use it.

Brian

 

[vX987]

OK, I finally figured out HOW to do this!

thanks for the suggestion!