consolidating records

[Alex Pejcic]

Hi all,

I have a query that returns the following list:

Widget1 11 pcs
Widget2 10 pcs
Widget3 5 pcs
Widget1 1 pcs
Widget3 7 pcs

How do I get a report or a query to display the consolidated info:

Widget1 12 pcs
Widget2 10 pcs
Widget3 12 pcs

I didn't have any luck searching through the archived groups. Any help
appreciated.

thanks,
Alex

 

[Duane Hookom]

Creat a totals query...
SELECT Widget, Sum(Pcs) as SumOfPcs
FROM qryYourQuery
GROUP BY Widget;

Duane Hookom
MS Access MVP

 

[ALex P]

Works like a charm.

Creat a totals query...
SELECT Widget, Sum(Pcs) as SumOfPcs
FROM qryYourQuery
GROUP BY Widget;

Duane Hookom
MS Access MVP