query for a renewal date again

[Guest]

Sorry I hit enter and it posted a blank question.
OK I have a Access 2002 database that contains a tabele called "Current
Members" with fields called "Active"(yes or no, check box) and a field called
"experation date" (full date ie: 1/1/2005) and email address(text, saved as a
hyperlink mailto

I need to queery the table for 1, are they active? and two the experation
date 60 days before the experation.

As an example the current experation date for some of the records is between
say 11/1/2005 and 12/1/2005. Results if met would be records I need to send a
reminder out for in September and October.

I'd like to return any record 60 days prior to those dates.
Is this doable or should I look at it from a different perspective to obtain
the same result?

Possibly for another forum I then want to add the email field on the
returned records to the BCC line in an Outlook e mail.

 

[Allen Browne]

You can create a query into this table.

In the Criteria row under the Active field, enter:
True

In the Criteria row under the date field, enter:
<= DateAdd("d", 60, Date())

Note that this is not an optimal structure. I suspect you need a related
table of membership details, where a record is added each time the member
pays their dues. Then next time they are due would then be calculated from
their most recent date in this table by using a Totals query (Totals on View
menu in query design.)

Use SendObject to send the email. There's an argument for the BCC.

 

[Guest]

I do believe this is going to work for me, Thank you.