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

Ms Access Dates

P: 2
I hope someone can guide me. I'm running MS Access 2002 and have hit a wall. I have a DB with two fields of dates and I need to create a query which will form a new field showing 1) Dates which occur after a given date and 2) A standard date e.g. 1/1/2003 for everything that occurs prior to the given date.

Thanks in advance, Eoin
Feb 16 '07 #1
Share this Question
Share on Google+
3 Replies

Expert 2.5K+
P: 3,072
Try a query like:
Expand|Select|Wrap|Line Numbers
  1. select IIF(YourDate<[The parameterdate (mm/dd/yyyy): ],[The parameterdate (mm/dd/yyyy): ],YourDate) as NewYourDate, ... from tblYours;
Feb 16 '07 #2

P: 2
That worked perfectly, many thanks for your help, Eoin
Feb 20 '07 #3

Expert 2.5K+
P: 3,072
Glad I could help, success with your application !

Feb 20 '07 #4

Post your reply

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