We help IT Professionals succeed at work.

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

cssc1
cssc1 asked
on
256 Views
Last Modified: 2014-08-03
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

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

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
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

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
CERTIFIED EXPERT

Commented:
Welcome!
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.