Excel IMPORT Issue - NZ Command

  • Thread starter Thread starter Schwimms
  • Start date Start date
S

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.
 
Ohh Doug!!

Your my hero!

Douglas J. Steele said:
Replace Nz([2005], 0) with IIf(IsNull([2005]), 0, [2005])

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Schwimms said:
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.
Click to expand...
Click to expand...
 
Back
Top