Add and check if customer age of 70 yrs?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to have a query that will check against another field (RMD) in my
query to see if the customer is 70 1/2 years old and to include any leap
year. How is this done?

I am trying to see if a customer can collect on his insurance based off a
field in my query. I need my query to check and make sure the cusotmer has
set up a "RMD" (also the field name) set up and if TRUE and he is 70 1/2
years old by the end of the current year.

Thanks in advance
 
Something like this should do it ...

SELECT tblTest.*
FROM tblTest
WHERE (((tblTest.DOB)<DateAdd("m",-906,DateSerial(Year(Date()),12,31))));

The DateSerial function gets the last day of the current year, and the
DateAdd function subtracts 906 months ((75 * 12) + 6) from that.
 
I need to have a query that will check against another field (RMD) in my
query to see if the customer is 70 1/2 years old and to include any leap
year. How is this done?

I am trying to see if a customer can collect on his insurance based off a
field in my query. I need my query to check and make sure the cusotmer has
set up a "RMD" (also the field name) set up and if TRUE and he is 70 1/2
years old by the end of the current year.

Thanks in advance
Click to expand...

What is RMD? What's its datatype, and how can it be "checked"? Do you
have a date of birth field? If so you can use a calculated field to
determine the person's age in months as of the end of the current
year:

DateDiff("m", [DateOfBirth], DateSerial(Year(Date()) + 1, 1, 0))

Use a criterion of >= 426 to select people who will be over 70 years,
6 months as of the end of the current year.

John W. Vinson[MVP]
 
Back
Top