Multiple Column sort.

[detaylor1242]

How do I create a macro that so that I can sort by multiple columns?



I think a macro would be required for each of the three sorts that I need to do. For example Macro 1 would be for Item number and PLU number, Macro 2 would be for Barcode Number and Unit Price. The order of the columns has to remain stable.

[JoeM]

You don't need multiple macros. You can store multiple queries, if you like, sorted by whatever/however many fields you want.

[Dal Jeanis]

Where do you want to use this, in a form or in a report? In a form, you could just set the ORDER BY property of the Form. In a Report, you have to fix other things.

[detaylor1242]

Where do you want to use this, in a form or in a report? In a form, you could just set the ORDER BY property of the Form. In a Report, you have to fix other things.

Can't change the order of the columns as it would really confuse the operators. I am dealing with older volunteers that are in their late 70's and up to 94 years old.

What I would like is a macro that they can run and and the screen will sort in the right order.

[JoeM]

What I would like is a macro that they can run and and the screen will sort in the right order.

This seems like a totally unnecessary step to me. How is the Macro going to know what order to sort by?
It seems to me like your Macro would just be opening up some pre-defined queries. So why not just open the desired pre-defined query?
Or am I missing something here?

[orange]

A macro is Not needed. As JoeM suggests, use a predefined query.

Sort order does not change the position of fields..... JUST the Order by which they are sorted.