Have a Table similar to the following:

Col 1 Col2 Col3
Part Number Description Count

A5 LD 10000
A6 B 15000
A6 B 2600
A6 LD 50000
A6 LD 20000
A7 B 102000
B12 D 35000
B12 D 20000
B12 B 3000
T34 H 2000
T34 B 75000
T34 H 65000

I want to do a query that would give me total counts for each item that has
matching part number and description

A5 _LD = 10000
(A6_ B) +( A6 _ B) = 17600
(A6_LD) +( A6_LD) = 70000
ect...

Can this be done in a query? Being just an Access Amatuer, I can't see how.
I have added calculated and concatenated columns, but my methods for that
won't work here.
Could someone help please?
Thanks - Sean

"What-a-Tool" <FrigginSpammersDieDieDie!@cox.net> wrote

Create a query and click on the Totals button (or View/Totals). This will
show a Total row in your query.
Add the three fields to your query and make Part Number and Description
"Group By" and make the Count "Sum".

The SQL should look something like:

SELECT PartNumber, PartDesc, Sum(Count) AS SumOfCount
FROM tblMyTable
GROUP BY PartNumber, PartDesc;

--
Bradley
Software Developer www.hrsystems.com.au
A Christian Response www.pastornet.net.au/reponse

Just wanted to say thanks. Prety basic stuff, I know, - just shows how much
of an amatuer I really am.
Thanks - Sean


"Bradley" <bradley (AT) REMOVETHIScomcen (DOT) com.au> wrote