Sorting by name

[Nova_C]

My database tracks computer assets. The assets are organized according to type, i.e. laptop, desktop, etc. Each asset type is associated with an ID number :

(this example comes from a table)
ASSET CATEGORY ID | ASSET CATEGORY
1 Laptop
2 Desktop

When I display them in a report, it sorts the category according to the ID number, but I want it to sort them alphabetically. How do I do this?

 

[Sohaila Taravati]

Open up your report in design view and click the sorting and grouping button. Choose the field you want to be sorted from your list of fields and your filed will be sorted the way you want!

Sohaila

 

[Nova_C]

That's what I've done and it sorts by the numbers, not the letters.

 

[David R]

Make sure you're sorting by the "Category" field, not the AssetID. You may have to add that table to your report query and drag down the field to get it to recognize it properly. If you're using a table lookup field it can get confused.

 

[Nova_C]

Thanks again, Dave. Worked like a charm.