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

Displaying results past a certain date

P: 5
Hey Guys,

I have a make-table query in which I'm tryin to display a table that shows results past a certain date (12/31/2006). The date column is in proper Date/Time format - Short Date format to be more exact. On my query, I have tried to input these commands under "Criteria":

>= #12/31/2006#
between #12/31/2006# and #12/31/3000#
>= #12/31/2006# and <=#12/31/3000#

None of these commands worked, and the table still shows results from 2005. Can you guys please tell me which command I should be using?

Thanks!
Aug 14 '07 #1
Share this Question
Share on Google+
2 Replies


missinglinq
Expert 2.5K+
P: 3,532
The only thing I see is that you have a space between the equal sign and the pound sign, which Access doesn't allow. Try correcting that and doule-checking that you have it in the right field. I did and then successfully ran

>=#12/31/2006#

on a db of mine set up exactly like yours with appropriate dates. You say you want dates past 12/31/2006, but of course the equal sign will pull that date as well.

Welcome to TheScripts!

Linq ;0)>
Aug 14 '07 #2

P: 5
The only thing I see is that you have a space between the equal sign and the pound sign, which Access doesn't allow. Try correcting that and doule-checking that you have it in the right field. I did and then successfully ran

>=#12/31/2006#

on a db of mine set up exactly like yours with appropriate dates. You say you want dates past 12/31/2006, but of course the equal sign will pull that date as well.

Welcome to TheScripts!

Linq ;0)>
Thank you very much for your help! I will see if that is the problem and get back with you.
Aug 15 '07 #3

Post your reply

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