Return values from five days ago

[reidn]

I have a query that needs to retrieve records from a table. The query only needs to take records that are no more than 5 days old or open. Code I tried looks like this...



WHERE ((([Work Orders].Status)="open")) Or [Work Orders].[Date Assigned]<=DateAdd("d",5,Now());

What could I be doing wrong? Any Ideas??
Thanks for all the help,

Reid

[RuralGuy]

Try:
WHERE ((([Work Orders].Status)="open")) Or [Work Orders].[Date Assigned]>=DateAdd("d",-5,Date());

[reidn]

Worked like a charm! Thanks Rural Guy

[RuralGuy]

Glad we could help.