Building a TickleDate System???

[Guest]

Hey guru's I need to build a tickle date system that works well! I've built
this Access 2007 data base which need to take the system date and take off 1,
2, 3 months off of the system date and return only those records that fall
within those dates. Example, if I have a person taking a subscrition which
expires in three months from the 1 year sign up date and have a Pop-Up that
record remind me to re-submit my application due to threat of experation of
the subscription 2 months before it expires!

Is that possible? If so how? Show examples. The date field in the table is
called str_ListDate. When a new record is created the current system date is
plugged into the table's field via a code function into the forms control
called txtList_Date! In this example the system date would be 01/03/2007. I
need to have a form or something like that pop up to remind me to check that
record and contact client for renewal!!

Thanks,

 

[tina]

in a query, for instance, use the following criteria on the table's date
field, as

WHERE DateFieldName < DateAdd("m", -9, Date())

the above will bring up all dates older than 9 months prior to today. if the
*current renewal* date is in a different field, you'll need to add criteria
there also, to filter out the renewed records.

hth