I have a DB with a single line subcatagory on each line.I
want to sort the entire DB based on each lines sub. Is this
possilbe. To be clear I do NOT need to sort the information
in the sub itself. I want to use the value in the sub to
sort the entire DB.
Thanks!
A bit of jargon here:
A Database, in Access, is the .mdb file. It's a container for multiple
Tables, Forms, Queries, Reports and other objects. You can't sort "a
database" because it's heterogenous.
Your data is stored in a Table. A Table cannot be sorted; it's an
unordered "bag" of data.
Create a Query based on your table. If this subcategory is a Lookup
field, then it is NOT in your table; Microsoft's misdesigned,
obnoxious Lookup misfeature is just concealing it from your view. If
it is a lookup field, add the lookup table to your Query and select
the subcategory from that table. Select "Ascending" on the Sort row in
the query grid.
Open the query; you'll see all the records in your table sorted
alphabetically by subcategory.
If you mean something else by "sort the information in the sub itself"
and I'm misunderstanding, please accept my apologies and clarify!
