Sorting: Prioritizing Fields for sort

[Guest]

Please read through this example...
(i) I have a query with three fields: Name, Age and Height

(ii) There are five records
NAME AGE HEIGHT
John 22 70
Jane 33 64
Bob 70 69
Fred 70 66
Mary 67 65

I want my summary to sort by Age first (descending), and then by height
(descending), so since Bob and Fred have the same age, Bob will come first
since his height is > Fred.

However, whenever I sort “descending†age and “descending†height, the
summary only sorts “descending†age and ignores the height sort. How do I
fix this?

 

[Allen Browne]

The 2-field sort should work.

What data type are the Age and Height fields?

If they are Text type, you will get a text sort, so 9 will be larger then
10.

If they are Number of size Decimal, Access will not sort them correctly:
http://allenbrowne.com/bug-08.html

If neither of those apply, please post a follow-up indicating the Type and
Size of the fields in your table (table design view), and the ORDER BY
clause of your query (SQL View on View menu, from query design.)