Aggregate parts list query

  • Thread starter Thread starter Larry
  • Start date Start date
L

Larry

This is what I call a parts list query. The table queried
looks like:

Ref.Des. Part No. Value
-------- -------- -----
R1 ABC 50
R2 ABD 100
R3 ABC 200
R4 ABC 50

Note that there is a duplicate combination: ABC 50.

The SUM query I am after would group the Part No. and
Value fields, and aggregate all the Ref. Des. entries that
are found in a unique group. Thus the output would be:

Ref.Des. Part No. Value
-------- -------- -----
R1, R4 ABC 50
R2 ABD 100
R3 ABC 200

If, in the SUM query, I select:

Ref.Des. Part No. Value
-------- -------- -----

COUNT GROUP BY GROUP BY

Then I get the output:

Count Ref.Des. Part No. Value
-------------- -------- -----
2 ABC 50
1 ABD 100
1 ABC 200

I need to know how go get from this to the list of Ref.
Des. entries, in addition to or instead of the COUNT.

Larry
 
Dear Larry:

I'd like to refer you to my response to Mike above. Same old, same
old.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Back
Top