Date Problem

[fixious123]

Right now I have a query pulling dates that expire within 30 days and works fine. How do I continue to pull that and include all dates that are expired also?
Thank you

 

[Mile-O]

WHERE ExpiryDate <= DateAdd("d", 30, Date())

 

[ColinEssex]

If you have a query that pulls records for the next 30 days, then any date in the past has presumably expired also. You could add on a new criteria line <Date() this will pull up all records before today.

Perhaps you could be a bit more detailed in exactly what you want

Col