Sum and Count of fields in one Query (SQL for Access)
Posted on 2003-11-26
I have a table on Transaction Sales
Here is the structure of my table
A Transaction ALWAYS includes 6 Products. If a product was not purchased during a transaction
Then it's value is set to 0.
I want to display the SUM and the COUNT of each Product in one single Query
When the Value of ProductX is 0 then I don't cumulate it in COUNT.
Here is a desired Display example:
Product 1 = Sum ; Count
Product 2 = Sum ; Count
Product 3 = Sum ; Count
Product 4 = Sum ; Count
Is this possible in one Query ???