Sorting multiple fields

[Bill Armitage]

I have a database application with a table of members and
I used the 'Build Event' to create a query that sorts
selected data into a report (for printing). This all
works so long as I only have one (field) sorted.
I really need to sort by 3 (or 4) fields at the same
time - Surname then Street (then No) then FirstName - but
I can't see how to do this.
I know that this can be done, I just can't figure out how!
Any help on this would be greatly appreciated.

 

[Rick B]

While in report design, click on the Sorting and Grouping button. From
there, you can select several sort levels and decide if each should have a
header or footer section for totals. If you can't find the icon on your
menu bar It is also under the "View" menu.

Rick B


I have a database application with a table of members and
I used the 'Build Event' to create a query that sorts
selected data into a report (for printing). This all
works so long as I only have one (field) sorted.
I really need to sort by 3 (or 4) fields at the same
time - Surname then Street (then No) then FirstName - but
I can't see how to do this.
I know that this can be done, I just can't figure out how!
Any help on this would be greatly appreciated.

 

[Bill Armitage]

Rick B.
Many thaks Rick for your speedy and very helpful reply.
I have just created a report using your suggestion and it
worked a treat. However, I need to create a plain table
(columns and rows) as a result of a query. Can I modify
the query code to include multiple field sorts?
Sorry for being a bit obscure in my requirements.
Bill Armitage

 

[Rick B]

Yes. Just put the fields in the order in which they should sort and select
the appropriate sort order under each field. You could, for example, sort
by Last name in ascending order, and then by birthdate in descending order
by putting those two items in your query in that order.

Rick B


Rick B.
Many thaks Rick for your speedy and very helpful reply.
I have just created a report using your suggestion and it
worked a treat. However, I need to create a plain table
(columns and rows) as a result of a query. Can I modify
the query code to include multiple field sorts?
Sorry for being a bit obscure in my requirements.
Bill Armitage

 

[Bill Armitage]

Rick B.
Many thanks!!!
Not only very informative but exceptionally fast.
I really am appreciative that you have taken the time and
effort to help in this way - especially with a rather ill-
defined initial request.
Gratefully yours,
Bill Armitage