NOT Sorting at all

[eld]

Hi,

I have a report that contains a subreport, and it is based on a query. I use
the Grouping an Sorting function to the define the fields I want to sort by.
In this case ProductID and Colors . However, the sorting does not happen, not
even in the color field. Nevertheless, if I sort only by color then it does
sort according the color field.

How can I solve this frustrating problem????

Thx

 

[Jeff Boyce]

Are you saying that adding the fields into the Grouping/Sorting grid does
NOT work in the report definition?

Have you tried re-creating the report from scratch? Sometimes a subtle
corruption can sneak in.

Do you have Track Name Autocorrect turned on? Check Tools | Options |
General tab -- there's a reported bug that affects report definitions in
some versions of Access if this option is left checked.

Regards

Jeff Boyce
Microsoft Office/Access MVP