current date minus a day!

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

I am stumpped!

I need help building an expression in a query. I need to
build an expression in the criteria field that will bring
up data from a table that was entered in yestday. I need
to run this query daily so I don't want to enter in the
current date everytime i run this query. Can I use the
current date expression minus 1 day some how?
e.g. =date()-1"d" (is not working.)
 
Back
Top