I have a simple table in MS Access and i'm having trouble returning orders that have been entered yesterday from the OrdersDate column. I tried DateAdd("d",1,Date()) but when I
run the query it returns all the order numbers from my table and the OrderDate field just displays yesterdays date down the entire column. Would my date format have anything to do with this. The OrderDate columns field is "9/24/2013 16:22"
Any other methods? Thanks