SQL syntax for SUM

[katkat77]

I am using Excel VBA do write a SQL query using ADO.

E.g. of my query:

Select Item,Sum(BookValue) From ItemLedger Group By Item

How do I modify my query such that those items with Sum(BookValue)=0 will not be retrieved?

[ConneXionLost]

Include a HAVING option in your SQL statement.

Cheers,

[katkat77]

I have tried

Select Item,Sum(BookValue) From ItemLedger Having Sum(BookValue)<>0 Group By Item

But it returns an error.

[ConneXionLost]

This example SQL statement works:

Please Login or Register  to view this content.

If the same structure doesn't work for you, then perhaps it is the VBA you're using to run it.

[romperstomper]

Assuming you don't have negative BookValues, why not just add a:
WHERE BookValue > 0
clause?

Please Login or Register  to view this content.

[katkat77]

Hi guys,

Thanks for your help. I've got it working. I didn't know sequence of the syntax makes a difference and that GROUP BY must be before HAVING.