Count rows in Query 1

[JPimp]

For some reason I can count the total rows, if that is all I want, but if I want other fields as well, I receive an error that there is either a mislinked field or no data exists (although I know there is).

This is the query code:

SELECT DEPARTMENT, COUNT(*) AS TTL FROM WO_WORK_ORDER

Just call me Spunky

 

[Turkbear]

Hi,
You need to add a GROUP BY statement including any fields requested prior to the aggregate function ( COUNT, SUM, AVG, etc)

In your example it would be:

SELECT DEPARTMENT, COUNT(*) AS TTL FROM WO_WORK_ORDER
Group By DEPARTMENT

This will give the count in each Department..






To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[JPimp]

Awesome!! Thank you so much Turkbear!

Just call me Spunky