dlookup failure

  • Thread starter Thread starter rong
  • Start date Start date
R

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
 
rong said:
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
Click to expand...

Try this:

=IIf([premium]=0,Null,DLookUp("[totalpremium]","qtotalprems","[netwtpeawt04.name]='"
& [name] & "'")).

Tom lake
 
Back
Top