I have a database that has a date filed mm/dd/yyyy. I'm trying to set the criteria in the query to olny show me the prior days information. In other words I want to always see what infomation was entered yesterday. If today is friday I want to only see thursdays info. I've tried different things but have not made it work yet. I know its going to be something with Now()-1 but cant seem to get the syntax right. ANy help would be appreciated.