count the value in a iif conditional expression

[julsie]

i need to count the value contained in several records for a specific condition. what's the best approach??

 

[carp]

Try<br>
<br>
SELECT count(*)<br>
FROM your_table<br>
WHERE your_condition_exists;

 

[julsie]

I have it counting for a qty field which then sums by certain levels. I'm wondering a count (iif) statment is required?

 

[carp]

Could you provide a small sample of data and the output you desire? This would make it much easier to work on a solution.

 

[julsie]

fields are qty/condition/location<br>
<br>
qty can be any number (5,4,3,2,1), condition is either A or F, location is one of wh, proj, prog<br>
<br>
if i have several records that are the condition A i want to see the count of the qty and sum it by location????

 

[carp]

OK, let's try this:<br>
<br>
SELECT location, count(qty), sum(qty)<br>
FROM your_table<br>
WHERE condition = 'A'<br>
GROUP BY location;