When creating a Query I would like the columns to be in a particular order every time I run / access the query. I select the fields that I want in the Query, and then I am able move the columns to where I want them to be, so that when I export to Excel the columns are where I want them to be. I then exit the query. However, next time I go into the query, the columns have reverted back to the original order, meaning I have to re-order them every time I run the query.
Describe the Challenge | Efficiency of running queries |
I have exactly the same issue. I run a report on active candidates every day and export it to Excel, then have to rearrange the columns. It would save so much time to be able to set up the Query with the columns in the preferred order.