Counting different items in one field in a table

[ignacious]

I am trying to get a report, with a count, from a particular field in a table that has two possible entries.

FieldName
Item1
Item2

I would like to know how many of each item there is

Item1 = X
Item2 = X

Thank you
Ignacious

 

[MLZ]

Ignacious,

Not sure if I understood your question but you may try these selects.

Count for Item1:

select count(FieldName)
from yourTable
where FieldName=Item1
group by FieldName

Count for Item2:

select count(FieldName)
from yourTable
where FieldName=Item2
group by FieldName

Hope this helps.

--mlz

 

[ignacious]

I will try to be a little more specific. In the table I have

FieldName
Item1
Item2

I need to create a query or report to count how many of each item is listed in the FieldName. So then I would have a report that shows the quantity of each.

 

[r937]

select Fieldname,count(*)
from yourtable
group by Fieldname

rudy

http://r937.com/

SQL Consulting