Previous Date

[chaka]

I would like for my query to have a criteria of the previous date, not the
current date.
how do I do this

 

[tina]

well, if you mean yesterday's date, instead of today's date, try

Date()-1

hth

 

[John Vinson]

I would like for my query to have a criteria of the previous date, not the
current date.
how do I do this

If the table field contains just a date with no time portion use a
criterion of

DateAdd("d", -1, Date())

If it contains both date and time (e.g. if it's filled using the Now()
function) use

= DateAdd("d", -1, Date()) AND < Date()

John W. Vinson[MVP]