Split Categories

[mtownbound]

I need to split certain categories into multiple rows. Currently, I have the categories grouped in my report as:

1) Reebok
2) Nike
3) Addidas

However, what I need is:

1) Reebok
2) Air Jordan #Formerly grouped in Nike Category
3) Nike Airs #Formerly grouped in Nike Category
4) Adidas


Thanks!!

 

[dhookom]

Can you share the significant tables and fields? How about the SQL view of the report's record source?

Duane
Hook'D on Access
MS Access MVP

 

[mtownbound]

It's a basic tblShoes with the minimum fields (txtManufacturer, txtType, txtPrice) with txtManufacturer being the field I'm grouping on. As for the SQL view, no joins or anything....Select tblShoes.txtManufacturer,tblShoes.txtType,tblShoes.txtPrice FROM tblShoes

 

[dhookom]

Does it work to just group by manufacturer and type? Are there other types for Reebok and Adidas that you don't want grouped?

Ideally you would have a table of unique manufacturers and types with a column that identifies the grouping to use in the report.

Duane
Hook'D on Access
MS Access MVP

 

[mtownbound]

If I group on manufacturer and type, I still get "Nike". I would like to just replace "Nike" with either "Jordan" or "Airs" based on the type while reporting the basic names for the other brands.

 

[dhookom]

Create the table I suggested and use it. That's the only alternative that I would support.

Duane
Hook'D on Access
MS Access MVP

 

[mtownbound]

Ok, I'll try that. Thanks!