Nz queries

[sjackson1234]

Hi

Could you help me, i want a query to show one field from one table if that is blank then another field from another table, then if that it blank return " ". Can this be done. I have set up

Exp3: Nz([tbl_lead_worker]![Role],[tbl_initial_worker]![Role]," ")

but when i run the query get a message saying

'wrong number of arguments withfunction in query expression.'

Do i need to use a different query function?

Many Thanks in advance

 

[MagicMan]

Is this part of a select, an expression builder or vb code?

 

[sjackson1234]

It is an expression builder.

 

[MagicMan]

ok, thought so,
Try Iif(IsNull([tbl_lead_worker]![Role]) = True,Iif(IsNull([tbl_initial_worker]![Role]) = True," ",[tbl_initial_worker]![Role]),[tbl_lead_worker]![Role])
I hope the format is correct....haven't done this in a while, and it is off the top of my head....will check it out in a few and get back to you if wrong

Just tried that expression (with my field) and it works fine on my db.
Smiles
Bob

 

[sjackson1234]

That works a treat - thank you so much

 

[MagicMan]

Your Welcome .... and welcome to the Forums!