In Access, what expression would pull up previous day's record?

S

spc23

We're creating an accounting system for Access, I can't seem to figure out
what expression I would use to pull up the previous day's total. Thanks
 
K

KARL DEWEY

Use Date()-1 as criteria.

Bear in mind that if your DateTime field has a time component then you need
a different query setup.

You would need to add a output column like --
SubDate: CVDate(Int([YourDateField]))

This removes the time component from YourDateField
 
T

Tom K via AccessMonster.com

Make a parameter query that shows all records except those that are not on
yesterdays date. The parameter would be Between "date" And "date".

Tom
 
Top