Link to home
Create AccountLog in
Avatar of CompTech810
CompTech810Flag for United States of America

asked on

Access: Group simular field values but show the detail of another field at the end of the line

Hope someone can help me on this!

I need to create a quote report that groups the similar field (quote#) values but shows the detail of another field at the end of the line.
Example records in detail:

Quote #            Part#           Supplier
1234                   99999           ABC
1234                   99999           DEF
1234                   99999           GHI

I need it to group/display like this.

Quote #            Part#           Suppliers
1234                   99999           ABC  DEF  GHI

Hope this make since.

Thanks!
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

ASKER CERTIFIED SOLUTION
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Avatar of CompTech810

ASKER

Sorry, got pulled away on another issue.  Looking at it now.  Thanks!!  I'll let you know.
Wow, your right that was tricky.  Wish I would have known that groups where hidden and the report has to be in print preview to work.  Pretty tricky.  Thanks!!
There are a couple of way that this could have been done.
I use my approach (instead of summarizing the data ahead of time), in case I need any of the "detail" data.