Add a day field to your query like this:
DaysAgo: DateDiff("d",[YourDate],Now())
This will tell you how many days ago it was.
Then add a criteria to this field like this:
>=29 And <=38
This will limit the result to all records that are between 29 and 38 days old.
HTH
mmcdonal
|