 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / January 2006dlookup failure
Can anyone tell me what is wrong with the following syntax. =IIf([premium]=0,Null,DLookUp("[totalpremium]","qtotalprems",[netwtpeawt04.name]="[name]")). I've tried it several ways with the [ ],s. I just doesn't return a value even with one in the query. all return null thanks, Rong > Can anyone tell me what is wrong with the following syntax. > =IIf([premium]=0,Null,DLookUp("[totalpremium]","qtotalprems",[netwtpeawt04.name]="[name]")). > I've tried it several ways with the [ ],s. I just doesn't return a > value even with one in the query. all return null > thanks, > Rong Try this: =IIf([premium]=0,Null,DLookUp("[totalpremium]","qtotalprems","[netwtpeawt04.name]='" & [name] & "'")). Tom lake |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.