CompTech810
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!
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!
Try this as well:
Database125.mdb
Database125.mdb
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
Sorry, got pulled away on another issue. Looking at it now. Thanks!! I'll let you know.
ASKER
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.
I use my approach (instead of summarizing the data ahead of time), in case I need any of the "detail" data.
https://www.experts-exchange.com/Microsoft/Development/MS_Access/A_2380-Domain-Aggregate-for-Concatenating-Values-by-Group-in-Microsoft-Access.html