Totaling Query

[Guest]

Hey all,
Let me try to explain this. I am creating a query to take the sum of
transactions for a certain ID# in one table and subtract them from the
original fund amount. The problem is, some funds have no transactions giving
them a null sum. So when I run my query, I only get results for the funds
that have transactions. How would I set up a query to give me a result for
every fund. Sorry it is remedial. Thanks, Adam

 

[David F Cox]

It is late, not tested:

NZ(SUM([total]),0)