Re: Filtering out zeros

Tom,

A piece of sample code or a little more explanation would help. I assume
you do not mean:

SELECT AccountCode, AccountValue
FROM AccountTable
WHERE AccountValue <> 0

Perhaps you mean:

SELECT AccountCode, SUM(AccountValue) AS TotalValue
FROM AccountTable
GROUP BY AccountCode
HAVING SUM(AccountValue) <> 0

RLF

"Tom" <Tom@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3EAC5984-4844-4223-B910-20E81B0F2E41@xxxxxxxxxxxxxxxx
Running a query that adds up certain fields in our database and where
applicable returns a zero total. Looking for a way to return only those
lines that are not zero value.

I'm new to this SQL thing, have experience in Access but am tripped up on
this. Pls Advise


.