Finding Yesterday in a Query

[TJBernard]

I have a query that is pulling in a date field [Order Date](yy/mm/dddd) and I want to find all the records where the date field = yesterday (so if today is 12/9/2002 I want all the records where the [Order Date] = 12/8/2002). I was trying to figure out a function to do this and decided to go a head and ask the board. If anyone has any ideas let me know.

Thank you,

T.J.

 

[dkuntz]

Date()-1

or

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

or

#12/08/2002#