Need to capture various durations (dates) for mailings 1

[jujutsu101]

First, thanks for the great help I've received by various programmers. OK, I have a simple carpet cleaning database. One of the forms (Customers) has Billing Address and Site (of cleaning) Address. Usually they are the same address. (Especially if a home and not a corporate headquarters). Now my friend wants to have the ability to send mailings to them (for instance) every so many months. (For instance quarterly, twice a year, yearly, etc.). What would be a simple way to do this?

Thanks in advance!

Fred
jujutsu101@hotmail.com

 

[MichaelRed]

First, add a field to the db for 'last mailing date'. Generate a query based on this field using using the date to derive the calculated field based on the date & desired offset.

For instance, if the last maing date field was [LastDt],

criteria ~~ Date >= [LastDt] + 180

Would return the customer's where the previous mailing was ~ 6 months.

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over