Date Of Birth Field

N

Nick

I have two questions if anyone can help. I need to
calculate birth dates from Now().
(1) How can I set the criteria on a date field so that the
birth date returned is equal to or greater than 12 years.
(2) The second question is how can I set up a field that
looks at the date field in years, without Access rounding
up to the next year? That is if a date 20 years, 8 months,
3 days the result is 20 not 21 years.

Help appreciated.

Nick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

querry sql problem for previous month 4
Calculate age in total months only 5
change result of field based on another field 10
Update Query - Calculation of person's age in Years - DateDiff??? 9
Calculating age from date of birth and ignoring if blank 5
Running query about date 3
IIF question 8
date - age query 4

Top