From the course: Access 2016: Queries

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Sort dates chronologically

Sort dates chronologically

From the course: Access 2016: Queries

Start my 1-month free trial Buy for my team

Sort dates chronologically

“

- [Voiceover] When using the format function to alter the way our date values are presented, it converts our date values into text strings. Sometimes this doesn't have any consequences on the presentation of your data, unless, of course, you want to sort your data chronologically instead of alphabetically. When you want to present your data as text, but still sort it numerically, you might need to get creative with your query design. Let's take a look at an example of this. I've currently got our ordered details query up that we created earlier in the course. This is a query where we took the quantity of each product ordered, and multiplied it by the price here as unit price. To get the total price for each of our orders. Let's go ahead and build a query off using the Wizard. I'm going to go to the create tab, and go into the query Wizard. We're going to use the simple query Wizard, and say okay. Now because I've currently got this selected here, it's automatically choosing this…

Contents