I am new to Access programming, but am familiar with Access programming.

I have a range of cells linked to a Query in Access that produces null
values. I used the the Nz function in Access to convert the null values to
"0" (Ex. Nz([DISCHARGES],0,[DISCHARGES]), but when I refresh the data in
Excel, Excel does not recognize the Nz function.

I tried to write a n If statement into the SQL statement, which accomplishes
the same thing on the Access side, but then when I refresh in Excel, I get a
message saying "too few parameters".

I need for the empty cells to convert to zero for use in functions that
display averages over time.

What is the best way to deal with this? Write code that replaces the empty
cells with zeros? If so, where would I put it?

Thanks in advance.

DEI