Alternate to NZ - Link Access to Excel

[eka24]

Please the quer below works fine but I cant get in excel because of the NZ.
Cann anyone help me modify it so I can link it to excel'

Payment: (IIf([IncomeExpense]="Expense",(Nz([PaymentAmount]))+(Nz([BankAmount]))+(Nz([Payable]))+(Nz([PaAmount])),0))


thanks in advance

 

[arnelgp]

You can use that in linked excel.

Alterate:
Val([PaymentAmount] & "")

 

[eka24]

Please I want to be clear should I replace all NZ with VAL.

 

[eka24]

Please the objective is the have the query appear in Excel. As it is it doesn't show but other queries without NZ shows.

 

[The_Doc_Man]

I believe Excel allows you to set references. You need to tell Excel to use the Access library (just like you would tell Access to use the Excel library if you wanted Excel's functions in a database.)

 

[eka24]

I believe you my question wasn't clear to you. I have already linked my access to excel which updates when data is changed in access. However queries in my database with NZ Do not appear as part of the queries in the excel. I did some search which point to the usage of Nz as excel doesn't recognize it.
How do I modify the query above to exclude NZ. hope is clear now

 

[Gasman]

Shouldn't that be

Payment:IIf([IncomeExpense]="Expense",Nz([PaymentAmount],0)+Nz([BankAmount],0)+Nz([Payable],0)+Nz([PaAmount],0),0)

See the note about valueifnull argument.

https://support.office.com/en-us/article/Nz-Function-8EF85549-CC9C-438B-860A-7FD9F4C69B6C

Please the quer below works fine but I cant get in excel because of the NZ.
Cann anyone help me modify it so I can link it to excel'

Payment: (IIf([IncomeExpense]="Expense",(Nz([PaymentAmount]))+(Nz([BankAmount]))+(Nz([Payable]))+(Nz([PaAmount])),0))


thanks in advance