Using Criteria As Filter In Query (date), Access 2003 1

[netrusher]

I am wanting to use criteria in a query that will allow me to filter data based on a date range like: >25 days but <50 day. I possibly would like to see data that is more than 25 days old but less than 50 or more than 50 and less than 75, etc. This would be based on a "StartWaterDate" field. This field would have a date that water was started. Thanks for help.

 

[PHV]

WHERE DateDiff('d',StartWaterDate,Now()) BETWEEN 25 AND 50

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[netrusher]

Thanks PHV, I will give it a try!