Access Query

[dan]

I have a database that has a date filed mm/dd/yyyy. I'm trying to set
the criteria in the query to olny show me the prior days information.
In other words I want to always see what infomation was entered
yesterday. If today is friday I want to only see thursdays info. I've
tried different things but have not made it work yet. I know its going
to be something with Now()-1 but cant seem to get the syntax right. ANy
help would be appreciated.

 

[Guest]

dan,

Try: Date()-1 .

-Michael

 

[Joseph Meehan]

From the help file:

< Date( ) - 30 For an OrderDate field, orders more than 30 days old


You should be able to take it from there.

 

[Guest]

You might want someting different if you do not work on Saturday and Sunday.
Below check day of the week and if it is Monday pulls Friday's records.

IIf(Weekday(Date())=2,Date()-3,Date()-1)