Textbox dlookup problem 1

[Danglez]

I have three textboxes that give the balance of 3 different accounts. They are called 'GCI', 'NY', & 'IBF'

Their control sources use dlookup to get the value from two queries for each respective account. My problem is the the NY and GCI boxes are working fine but the IBF one keeps coming up blank.

I have tried copying the NY and GCI sources and get the right number but as soon as I change the name to IBF I get a blank box.

NY Control Source (works fine):
=(DLookUp("[Branch Sums Maturity]![SumOfCashflow]","Branch Sums Maturity","Branch= 'NY'")+DLookUp("[Branch Sums Value]![SumOfAmount]","Branch Sums Value","Branch='NY'"))/1000000

IBF Control Source (Blank Box):
=(DLookUp("[Branch Sums Maturity]![SumOfCashflow]","Branch Sums Maturity","Branch= 'IBF'")+DLookUp("[Branch Sums Value]![SumOfAmount]","Branch Sums Value","Branch='IBF'"))/1000000

Any Ideas??
Thanks in advance

 

[LittleSmudge]

Are you totally sure that
DLookUp("[Branch Sums Maturity]![SumOfCashflow]","Branch Sums Maturity","Branch= 'IBF'")

does actually yield a valid numerical result ?


Are you totally sure that
DLookUp("[Branch Sums Value]![SumOfAmount]","Branch Sums Value","Branch='IBF'")

does actually yield a valid numerical result ?


If not then try

=(Nz(DLookUp("[Branch Sums Maturity]![SumOfCashflow]","Branch Sums Maturity","Branch= 'IBF'"),0) + Nz(DLookUp("[Branch Sums Value]![SumOfAmount]","Branch Sums Value","Branch='IBF'"),0))/1000000




'ope-that-'elps.



G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[Danglez]

That Worked! Thank you, could you explain a bit what the NZ function does and how that worked because I think I could apply to some other textboxes which would simplify some things for me.

 

[LittleSmudge]

Your best bet for 'how does it work' type questions is to refer to the HELP section and read the 'official' line.

Highlight the Nz and hit F1





G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.