#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)
 
Back
Top