Grouping in Reports

[Guest]

I have a report that I'm grouping by product group. Inventory items are grouped by their first six characters. For example 575101001 and 575001005 are both of the same product group. This works perfectly using the sorting option in design view by sorting on SKU in ascending order. Group header and footer both to yes. Group on Prefix character and group interval is set to six. Howver when I want to include 575001 as well in the product grouping it doesn't group at all displays everything as aseperate group. How can I group products in the same group where for example 575001, 575001001, and 575001005 would all be in the same group.

 

[Fons Ponsioen]

In the Sorting/grouping set the order to =Left([product
group],6). I cannot see a reason this would not work.
Hope this helps.
Fons

-----Original Message-----
I have a report that I'm grouping by product group.

Inventory items are grouped by their first six
characters. For example 575101001 and 575001005 are both
of the same product group. This works perfectly using the
sorting option in design view by sorting on SKU in
ascending order. Group header and footer both to yes.
Group on Prefix character and group interval is set to
six. Howver when I want to include 575001 as well in the
product grouping it doesn't group at all displays
everything as aseperate group. How can I group products
in the same group where for example 575001, 575001001, and
575001005 would all be in the same group.