Sort Not Working

[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

 

[Bruce]

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

 

[John]

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.

.

 

[Duane Hookom]

Are the text boxes for sure in the detail section of the report? Is there
any code in the report?