query previous day

samuel · Aug 1, 2006

i have a field [TransactionDateTime]

is there a way to display only when [TransactionDateTime] = TODAY-1

Klatuu · Aug 1, 2006

[TransactionDateTime] = DateAdd("d", -1, Date())