#error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I have a report that has over 200 pages. The lookup is the same for each
one,ex: =IIf(NZ(DLookUp("[Amount]","AG Single Acct
Summary","[VPN]=Parent![VPN] And [RSC
Account]='4380.3'"))+NZ(DLookUp("[Amount]","AG Single Acct
Summary","[VPN]=Parent![VPN] And [RSC
Account]='4385.7'"))+NZ(DLookUp("[Amount]","AG Single Acct
Summary","[VPN]=Parent![VPN] And [RSC
Account]='4390.7'"))=0,"",NZ(DLookUp("[Amount]","AG SIngle Acct
Summary","[VPN]=Parent![VPN] And [RSC
Account]='4380.3'"))+NZ(DLookUp("[Amount]","AG Single Acct
Summary","[VPN]=Parent![VPN] And [RSC
Account]='4385.7'"))+NZ(DLookUp("[Amount]","AG Single Acct
Summary","[VPN]=Parent![VPN] And [RSC Account]='4390.7'"))) and it works for
all but a few that do not have any value in those account numbers. I tried
putting in a zero, but it still does not work. Any help would be greatly
appreciated. Thank you. This is driving me crazy.
 
Mac,

Not sure if this will do the trick, but you could try adding the second
argument for the Nz function:

Nz( ... , 0)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ERROR MESSAGE 1
report summary 1
Is DLOOKUP the best choice? 4
Dlookup HELP 2
Report based on Crosstab Query 3
Division by Zero Error 1
query producing multiple lines of same data. 4
Iif Statements 1

Back
Top