Select by "Updated"

[wreded]

i've been through the FAQs and searched on Date and can't find an answer to my question.
i have a date/time field that is updated when user's change a record. It's updated as Now(0 so i get the whole blamed date/time thing. Anyway, i want to pull information on items that were updated yesterday. When i use a query with SQL criteria
SELECT Users.IndvName, Users.Rank, Users.IATestDate, Users.Updated
FROM Users
WHERE (((Users.Updated)=-1));
i get a blank record set.
Any ideas?
Thanks,
Dave

 

[PHV]

... WHERE CLng([date/time field]) = CLng(Now())-1 ...

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

 

[wreded]

Thanks! That works.
Dave