I have tried using a query to sort the data and for some reason it does not work.
On the “Events_frm” I am trying to add the chronological number of the Event along with the word Event at the beginning of the event description based on the date then time. For example:
“Event 1 – “ The man slipped – 10/22/2014 – 9:00 AM
“Event 2 – “ The man fell – 10/22/2014 – 9:15 AM
If the user enters the events in the wrong order, I want the application to put them in the correct order based on the date and time.