Sort Not Working

  • Thread starter Thread starter John
  • Start date Start date
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
 
Is Hide Duplicates set to Yes? This setting is located in
the text box property sheet, Format tab.
 
No, all the text boxes are set to No.

-----Original Message-----
Is Hide Duplicates set to Yes? This setting is located in
the text box property sheet, Format tab.

.
Click to expand...
 
Are the text boxes for sure in the detail section of the report? Is there
any code in the report?
 
Back
Top