http://support.microsoft.com/support.../q182/7/35.asp
XL97: How to Use the Query Before and AfterRefresh Events

--
Regards,
Tom Ogilvy


"DEI" wrote in message
...
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