How to figure a person's age in access

[Guest]

I want to figure a person's age from the birthday I receive from them and I
want it to update daily. What expressin would I use to do this? I would
also like, if possible, to link this to a yes/no check box that would let me
know if they are 21.

 

[Martin Widmer]

http://www.ocair.org/files/knowledgebase/HowTo/birthdate.asp

1 second of google... you can do it too, can't you?

Martin

 

[Dirk Goldgar]

I want to figure a person's age from the birthday I receive from them
and I want it to update daily. What expressin would I use to do
this? I would also like, if possible, to link this to a yes/no check
box that would let me know if they are 21.

http://www.mvps.org/access/datetime/date0001.htm

 

[BruceM]

As the other replies have shown, there are many resources out there for
questions such as this that are asked often. I would suggest that Google
groups is a good way of searching newsgroup postings. It is a good idea to
bookmark the Access MVP site, as well as other links that appear here, so
that you start to create your own reference library.
For your other question, what exactly do you need? You could use VBA code
in the form's Current event to set a checkbox to True if the age is 21 or
over, and False otherwise, but to what end do you wish to do this? See Help
for information about the DateAdd function for one approach.