Using Access 2000, is there a way to sort on multiple fields at the same time.
Here's what I want to do: I have a simple, three field database of CD's. The
fields are ARTIST, ALBUM and CATEGORY. I know I can sort any one of the fields
by itself. What I'd like to do is sort the ARTIST alphabetically and also have
the ALBUMs by that artist list alphabetically. I have a book and the online help
files but don't see how I can do it. I appreciate any help. Thanks.
Here's what I want to do: I have a simple, three field database of CD's. The
fields are ARTIST, ALBUM and CATEGORY. I know I can sort any one of the fields
by itself. What I'd like to do is sort the ARTIST alphabetically and also have
the ALBUMs by that artist list alphabetically. I have a book and the online help
files but don't see how I can do it. I appreciate any help. Thanks.