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

[Guest]

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

 

[Guest]

You can pull this single value using a subquery

R. Hicks

 

[Guest]

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

 

[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