Add and check if customer age of 70 yrs?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TKM - 31 Oct 2006 22:56 GMT

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

Reply to this Message

Brendan Reynolds - 31 Oct 2006 23:08 GMT

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.

Signature

Brendan Reynolds
Access MVP

>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
[quoted text clipped - 6 lines]
>
> Thanks in advance

Reply to this Message

John Vinson - 01 Nov 2006 00:55 GMT

>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
[quoted text clipped - 6 lines]
>
>Thanks in advance

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]

Reply to this Message