By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,960 Members | 2,324 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,960 IT Pros & Developers. It's quick & easy.

Selecting Records entered Yesterday

P: 194
Hi, i want to show my query the records which was entered yesterday. for example today is December 25, 2007 but when i run this query this query should reflect the records with the date December 24, 2007. What is the syntax doing this? please tell me.

thank u.
Dec 25 '07 #1
Share this Question
Share on Google+
1 Reply

Expert 2.5K+
P: 3,072
Go into the graphical designer and enter in the criteria field underneath the dat field:
Expand|Select|Wrap|Line Numbers
  1. Date() - 1
That should do the trick.

Dec 25 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.