Dlookup in if condition

[ootkhopdi]

Hi

i want to update data in table A
where [EMPID]= null

with other table B

i m using formula as

=IIf("[EmpId]"="#N/A",DLookUp("[Empid]","[B)]","[Account]='" & [Account] & "'"),"[EmpId]"="[EmpId]")
but it gives a messege of error

please tell me where is my fualt

thanks in advance

 

[Ranman256]

If you are using a query, you don't use DLOOKUP....
The query IS the DLOOKUP. You join your table to the lookup table to replace the values.

 

[ootkhopdi]

yes..
i am using dlookup in query

may not?

then how can i solve this..

please give me step by step solution
thanks once again

 

[Cronk]

You can use dlookup in a query but it is inefficient and inelegant.

See post #2: "You join your table to the lookup table"

If you are still unsure, post the sql you are using in your query.