J
John
I am having problems with the sorting / grouping. I have a
query which pulls in all the data I need for a report (it
works correctly and is not sorted itself). I have a report
with two sorts (no header or footer, both ascending). The
problem is, the report is not sorted correctly. Using
Access 2000.
Example:
Field1 Field2 Rest of the Data
Widget Metal ---
Exget Metal ---
Widget Plastic ---
Didget Plastic ---
The problem is if I sort 1 then 2 then I get the following:
Didget Plastic
Exget Metal
Widget Metal
when widget should show up twice for Plastic and Metal.
If I switch the fields I am sorting 2 then 1 then I still
have the same problem:
Exget Metal
Didget Plastic
query which pulls in all the data I need for a report (it
works correctly and is not sorted itself). I have a report
with two sorts (no header or footer, both ascending). The
problem is, the report is not sorted correctly. Using
Access 2000.
Example:
Field1 Field2 Rest of the Data
Widget Metal ---
Exget Metal ---
Widget Plastic ---
Didget Plastic ---
The problem is if I sort 1 then 2 then I get the following:
Didget Plastic
Exget Metal
Widget Metal
when widget should show up twice for Plastic and Metal.
If I switch the fields I am sorting 2 then 1 then I still
have the same problem:
Exget Metal
Didget Plastic