Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
"Yesterday" in an expression
mp9, Thank you for your quick response. I am still having problems. I tried your suggestion in the following expression: STOREMST.STORE NOT IN (Select storenum from XBR_STORE where transdate = date()-1; and XBR_STORE.AS_SALES_CT <> 0) I get an error: 'Date' is not a recognized function...- Whodini
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
"Yesterday" in an expression
What date expression would I use to create a SQL query to search a table from "Yesterday"?- Whodini
- Thread
- Replies: 4
- Forum: Microsoft: Access Queries and JET SQL
