I am writing a query in an access database. I am having a problem using the expression builder.

I have a date field and part of the query I am trying to write is to find dates that are greater than 29 days old and less than 38 days old from the current date. I am really new at this and i think i am way way off. can anybody help me please !!!! here is what i did ..

[Qrystatus]![date1] > 29 And «Expr» < 38

the error message i get is

   data type mismatch in criteria expression

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

Thank you very much.. I am going to give it a shot. Because I will use this query on a regular basis, I am wondering if I will have to the current date every time i run it ..