Make Nulls Show in Query - URGENT

D

DanR

Is the 'null' you are looking to generate actually a
zero. If so, you should set the default value in the
table field to zero. Null is 'empty' ; 0 is zero (which
is a number that can be totaled, as you indicate)
 

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

Calculations with possible null value fields 1
Null in detail, but zero in totals 3
Earned value (BCWP) showing as zero in chart 0
To Zero or not to Zero 5
Report Sub-Total formulas where a value is null 2
A ZLS being reported as null 9
sorting: cleared/null v/s "" 3
Need to format a number in a report, but no number options come up 2

Top