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

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
cssc1Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Randy PooleCommented:
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.
0
cssc1Author Commented:
I already tried that and the query works fine, however, the dates on ther form don't sort.
0
Randy PooleCommented:
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
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

cssc1Author 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
0
Randy PooleCommented:
Download the database I attached on my last post...
0
cssc1Author Commented:
can you please re-upload the database you previously uploaded. see errors.
error-on-download.jpg
0
Randy PooleCommented:
Here you go
Database7.accdb
0
cssc1Author 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?
0
hnasrCommented:
Or try this:
Using a select statement and ordering by Event_date and Event_time.
Database7-2.zip
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
cssc1Author Commented:
Wow!
I see what was done. Wow, I would have never figured that out.

Thanks for your patience with me.
0
cssc1Author Commented:
Thanks for the help.
I think I know what to do now.
0
hnasrCommented:
Welcome!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.