Totaling Records based on Text Field

[jercsr]

Hi,

I have a table with a list of parts. Each record has a description field. However, when I query to total the records, the records with the same description are not being sorted and totaled. How do I total all of the records with the same description?

Thanks in advance.

Jeremy

 

[traingamer]

Can you rephrase your question?
Do you just want the count of the duplicates?
Do you want the total count of all records with a description?
Or something else?

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[jercsr]

Greg,

I'm trying to get a total of all records with the same description.

Thanks,

Jeremy

 

[traingamer]

To get those with two or more, try:

SELECT Count(t1.[COLOR=red]ID[/color]) as Cnt, t1.Description
FROM TABLE t1
GROUP BY t1.Description
HAVING (((Count(t1.[COLOR=red]ID[/color]))>1));

To get all of them, remove the HAVING clause

Replace ID with your key field (or any non null field).

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[PHV]

SELECT [Description field], Count(*) AS Total
FROM [list of parts table]
GROUP BY [Description field]
ORDER BY [Description field];

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244