If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
#error
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. -- thank you mac |
#2
|
|||
|
|||
#error
Mac,
Not sure if this will do the trick, but you could try adding the second argument for the Nz function: Nz( ... , 0) "mac" wrote: 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. -- thank you mac |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Reserved Error - 1104 - Works in 97 not in XP? | beveritt | General Discussion | 0 | August 25th, 2005 05:07 PM |
Error message different in MDB and MDE | david epsom dot com dot au | General Discussion | 1 | September 21st, 2004 12:47 AM |
Continual Error 1321 Trying to Install Office 2003 | Chad Harris | General Discussions | 9 | June 11th, 2004 08:19 AM |
Product Key for Office XP | P.G.Indiana | Setup, Installing & Configuration | 1 | June 7th, 2004 03:22 AM |
Error #1321 MOS 2003 Setup | Chad Harris | Setup, Installing & Configuration | 1 | June 7th, 2004 12:22 AM |