update empty cells to auto populate to put in a zero

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have created a calculation in Access, however due to a crosstab query
leaving a cell blank this does not calculate. How can I fix this, I know if
a zero is put in it works, would there be something I can to do auto populate
if this is the only way.

Thanks heaps,
Chris
 
You can use Nz() in your query statement to substitute a zero for null

1. Open your query in design view.

2. Switch to SQL View (View menu).

3. The query statement will begin something like this:
TRANSFORM Sum(Table1.Amount) AS SumOfAmount
Add the Nz() like this:
TRANSFORM Nz(Sum(Table1.Amount),0) AS SumOfAmount
 
Back
Top