on stupid little tricks: how to sort a table by multiple columns in MSAccess
it's easy to sort by one column, you just right click on it and click sort ascending or sort descending, but to sort by more than one column (without creating a query) is a little tricky, here's what you have to do (Windows keyboard required)
you have to put the columns that you want to sort for, all together in order from left to right, you do this by clicking on the column header, and dragging it over
so if you have columns
A B C D E
and you want to sort by E, then by C you have to drag the E column so you have
A B E C D
next
- click on the first column you want to sort for,
- press and hold the [shift] key
- and click on the last column you want to sort
in the example, we click on column "E", press shift and click on column "C"
A B [E C] D
you then press the menu key and select sort ascending or sort descending
you can now move the columns back to their original position or wherever you want to have those columns
if you close the table it will ask you to save (the layout, position of columns, columns sorted by, etc) your changes, if you do save the changes, next time you open the table it will be sorted by the columns you specified and *everything* will be the way it was when you closed it
I often create programs with complicated configurations, and I store the configuration in access table(s), yes I could use XML, but MSAccess is so much easier to program against from different languages and you have a whole GUI at your disposal to design and enter data, and tricks like this just make life easier
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment