How do I sort a date field in asending order using ms access

cssc1
cssc1 used Ask the Experts™
on
I created a query named "Events_Qry" to sort the Date field on the form "Event_2of2_frm". The sort option in the query does not seem to work for the dates on the form. I tried a calculated field but keep getting errors.
Database7.accdb
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
The problem is you have the sort in your query on the Description field instead of on the Event_date field, just modify that and you should be okay.

Author

Commented:
I already tried that and the query works fine, however, the dates on ther form don't sort.
You need to do that, and also modify your Event_2of2 form to use that query for its data instead of the events table..
Database7.accdb
Should you be charging more for IT Services?

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
I modify  Event_2of2 form to use that query for its data instead of the events table, now I get the attached error message?
ERROR-Message.jpg
Download the database I attached on my last post...

Author

Commented:
can you please re-upload the database you previously uploaded. see errors.
error-on-download.jpg
Here you go
Database7.accdb

Author

Commented:
Sorry, but I have never had this problem before.

Could it be the version of Access I am using???

Can't open, same problem.

Can you send me a screen shot of what you have done?
Maybe I will be able to open the image?
Retired IT Professional
Commented:
Or try this:
Using a select statement and ordering by Event_date and Event_time.
Database7-2.zip

Author

Commented:
Wow!
I see what was done. Wow, I would have never figured that out.

Thanks for your patience with me.

Author

Commented:
Thanks for the help.
I think I know what to do now.
Hamed NasrRetired IT Professional

Commented:
Welcome!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial