before and after dates

[Guest]

I want to contact customers after their inital contact date between the 30 -
45 day after purchase. How can I get a query to calcuate 30 days and 45 days
after the initial contact date and at the same time use those to day criteria
as a filter from all of my other customers on file? I don't want to manually
calucate the date but have a report that informs me that it is time to
contact these particular customers.

Any help would be greatly appreciated?

 

[Guest]

I would add a flag field to indicate if the followup was completed. Then in
your query use this as criteria on the Contact_Date field --
<=Date()-30
Also use criteria to not pull records that are flagged as followup completed.

 

[John Vinson]

On Wed, 2 Aug 2006 13:13:47 -0700, D.F. Pierce <D.F.

I want to contact customers after their inital contact date between the 30 -
45 day after purchase. How can I get a query to calcuate 30 days and 45 days
after the initial contact date and at the same time use those to day criteria
as a filter from all of my other customers on file? I don't want to manually
calucate the date but have a report that informs me that it is time to
contact these particular customers.

Any help would be greatly appreciated?

Use a criterion on the Contact Date of

= DateAdd("d", -45, Date()) AND < DateAdd("d", -30, Date())

to select records where today's date is in that range.


John W. Vinson[MVP]

 

[Guest]

A query such as this should do it:

SELECT Customer, Address, Phone, SaleDate
FROM Customers INNER JOIN Sales
ON Customers.CustomerID = Sales.CustomerID
WHERE DATE() – SaleDate BETWEEN 30 AND 45
AND NOT Contacted;

where Contacted is a Boolean (Yes/No) column in the Sales table which
indicates if the customer has been contacted with regard to that sale.

Ken Sheridan
Stafford, England