Maybe someone can help me out. I'm pretty new to Access and built a nice useful app pretty quickly. I'm impressed by the forms. I like how you can separate the UI from the database with linked tables.
Anyway.
My report will only order/sort 4 columns even though the query that underpins the report has 5 ordered/sorted columns.
My query sorts/orders this way:
Customers -> Facilities -> Buildings -> Rooms -> Asset Categories
My report uses that query and sorts this way:
Customers -> Facilities -> Buildings -> Rooms -> (but won't sort Asset Categories)
The Asset Categories from the query are no longer sorted alpha ascending after I use the query in the report.
So for example, Monitors are showing before Cables, which should not be the case.
I noticed in the Report Wizard you only have the option to sort by 4 columns. Why the limitation? Is there a work around?
At least the grouping is working right.
Thanks,
Tom