• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 215
  • Last Modified:

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
0
cssc1
Asked:
cssc1
  • 6
  • 4
  • 2
1 Solution
 
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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 6
  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now