Excel IMPORT Issue - NZ Command

[Schwimms]

Hi,

I am having an issue in Excel where when I am trying to IMPORT a query in
from Access and there is the NZ command in that Access query, Excel will not
allow this import.

The NZ command is in the query because I need to sum up a couple rows. This
is what it looks like:

Cum Actuals: NZ([2005], 0)+NZ([2006], 0)+NZ([2007], 0)+NZ([2008],0)

I am looking for a way to add up the columns differently in access or maybe
there is a different Import option in excel that I could try?

Any help is welcome.

 

[Douglas J. Steele]

Replace Nz([2005], 0) with IIf(IsNull([2005]), 0, [2005])

 

[Schwimms]

Ohh Doug!!

Your my hero!

Replace Nz([2005], 0) with IIf(IsNull([2005]), 0, [2005])

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Hi,

I am having an issue in Excel where when I am trying to IMPORT a query in
from Access and there is the NZ command in that Access query, Excel will
not
allow this import.

The NZ command is in the query because I need to sum up a couple rows.
This
is what it looks like:

Cum Actuals: NZ([2005], 0)+NZ([2006], 0)+NZ([2007], 0)+NZ([2008],0)

I am looking for a way to add up the columns differently in access or
maybe
there is a different Import option in excel that I could try?

Any help is welcome.