INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Split Categories

Split Categories

(OP)
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!!

RE: Split Categories

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

RE: Split Categories

(OP)
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

RE: Split Categories

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

RE: Split Categories

(OP)
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.

RE: Split Categories

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

RE: Split Categories

(OP)
Ok, I'll try that. Thanks!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close