Hello everyone. I need help sorting a query and/or a report. I’m using Access 2013.
I have a movie collection database, and I want to create a query and a report for two of its fields. The fields are called DVDColor and DVDNumber.
The DVDColor field has records such as Blue, Green, Red, White, and Yellow.
The DVDNumber field is self-explanatory, going from 1 to 50 or more.
I created a query with DVDColor as the first field, and DVDNumber as the second field.
I ran the query, then sorted it, selecting DVDColor as the first field, and DVDNumber as the second field. So far, pretty routine.
The problem is minor but annoying: The sort created a list that was not in actual numerical order. Here’s what I see:
Blue 1
Blue 10
Blue 11
Blue 12
Blue 2
Blue 20
Blue 21
Green 1
Green 10
Green 11
And so on.
I did the same thing with a report, and the results were the same.
Is there a way to sort a list such as this so the numbers are in actual numerical order? If so, what’s the simplest procedure? Would it be simpler for me to replace the single-digit numbers such as 1, 2, 3, with 01, 02, 03? If that’s the easiest solution, how can I do that without it affecting numbers with two or three digits? Thank you! Warren Page