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

Need help with sorting by date

P: 6
I have a simple query of a table that includes the date field. I want the end user to be able to run the query and have it ask the user to enter the date that the user wants to see information from.

How can I accomplish this?
Aug 17 '06 #1
Share this Question
Share on Google+
2 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
In the criteria section of the query, under the datefield column put the following:

[Please enter date:]

I have used the "Please enter date:" prompt but you can use any piece of text that makes sense to the user


I have a simple query of a table that includes the date field. I want the end user to be able to run the query and have it ask the user to enter the date that the user wants to see information from.

How can I accomplish this?
Aug 17 '06 #2

P: 6
Thanks, that works great.
Aug 17 '06 #3

Post your reply

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