This is the first time I’ve tried to write a query in Base. I want to sort data in ascending order in six columns (fields) simultaneously, but the sort function seems to allow only three. Is there any way to sort all six at once?
Hello,
In the future, please be more specific the your information. Providing a sample file is often helpful or needed. A query can be written in many places and using many different methods.
Fortunately your mention of three was a key here. Three is all that is provided for in the dialog but once accepted (and you don’t actually need the dialog at all) you can enter more sort fields on the Sort line itself. Of course you must take care with naming. Here is one with four:
Of course you can simple use the query section to create then use here as a data source.
Thank you for the quick responses. The screenshot from ggk showed me exactly what I needed to do. If I’d spent a little more time studying the design process, I would probably have figured it out on my own, but as I said I’m new at this.
