Query by date

[fpmsi]

I need to select a group of records for a mailing that have not been mailed to in the last 90 days. This is based off a field called "Import_Date". The field is formatted as mmyyyy (092011).



Table: tblMailing
Field: Import_date (092011)

Steps:
Import Database - gets coded as say (122011)
need to have a query that selects all those new records (122011) and dedupes by first/last/city against records from the last two months so that it can be exported for the mailing.

So basically it would not select records that were imported in the last two months by those fields. Its a 90 day dedupe process

Any help would be greatly appreciated.

Thanks

[alansidman]

I'm confused. What is the relationship between 092011 and 122011. Do you want your query to return all records having a date greater than 092011 or greater than 122011. Your explanation is not quite clear to me. Please try again.

Alan

[fpmsi]

Sorry: Basically i just need to select records by the last 3 months.

SELECT *
FROM tblMailing
WHERE ([Import_Date] Between DateAdd("d",-90,Date()) And Date());

Then dedupe and collect the remaining records.


I think i have this process completed if my theory is correct:

Qry Select all records in table from last 90 days.
Dedupe query wizard by First/Last/City
Show unmatched query between the two results (90 day selected and dupe wizard)
Select records from unmatched that equal month(now())

Ryan.

[alansidman]

What happens when you test your theory? Works? Errors?

Alan

[fpmsi]

Sorry - I was still working on the queries as I responded to your comments.

It all seems to be working - although the duplication process isn't the best. May have to look for a better way to dedupe as the strict dedupe is missing dupes.

Thanks again.