Show field where date is = to yesterday

[LebronJames]

I have two fields, lname and dateentered. I want to have a query in Access 2000 that will display only the names where the DateEntered is dated yesterday... somthing like currentdate -1

 

[straybullet]

Design view of your query - in "criteria" enter date()-1

Let them hate - so long as they fear... Lucius Accius

 

[PHV]

Something like this ?
SELECT lname FROM theTable WHERE DateEntered = Date() - 1;
If DateEntered has time value:
SELECT lname FROM theTable WHERE Int(DateEntered) = Int(Date()) - 1;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244