Total Count

[KarenYT]

Hello,

I don't understand why I couldn't get the total Count from the SUM query.
Please help, I know it may be just a simple trick but I have been trying for hours, not able to get the solution !

Attached is the database which consists of the table and query.
Query : qry001
TotalPNwithDiff: DiffQTY
I want to get the total number of counts of those not having zero qty.
The number-format of the field DiffQTY in the table tbl001 was imported from SAP.

thanks,
Karen

[HansV]

You need to add the column DiffQTY twice: once to get the count, and once to specify the condition <>0. If you use one and the same column for this, the condition is that the count is <>0 instead of that DiffQTY is <>0. That is not what you intended.
If you need a column in a Totals query only to specify a condition, set its Total option to Where. This automatically clears the Show check box.
See the attached version:

Database1.zip

[KarenYT]

Hans, Thanks for your prompt response as always !
You beats me ! I was going to post to disregard my post !
When I was driving on the way home, I thought of that !
My mind was stuck at that moment :(