Counting Results: Passed/Failed!

[cap.zadi]

Hey there,



I have a Query in which i need to calculate the results:


Fields in Query:

Producttype
Product
Results (Paased/Failed)

so i want to calculate how many results are passed or failed for each Product:

thanks.

zee

[jzwp11]

One way is to use an aggregate query:

SELECT Results, Count(Product) as CountOfProduct
FROM yourquery
GROUP BY Results

[cap.zadi]

well, thats great it gives how many passed and failed. i am also looking to calculate ir by ProductType then for each Product how many passed and failed. so how it will be?
thanks

[cap.zadi]

hey thanks. it is solved. some times answers are just next to door and just need to open this. thanks man.

[jzwp11]

You're welcome. I'm glad you got the last step worked out!