If Sum is Null...

M

Marco Alting

Hi

I'm running a query which totals the fields in a table, but in some records
these fields are empty and the Sum returns Null. What I want now is when
Null is returned, the query shows 0.

Can you help?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

#error - Blank 3
How to return Max date or Null (if there is a Null present) 4
Query: Calculating 2
"Invalid use of Null" in query 3
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Need null values for several fields in db 1
Using checkbox to edit criteria 3
Testing for null 4

Top