Add info from another field if present field is empty

[glat]

Phil, sorry got caught up yesterday. Put in the SQL and receiving a message saying "Syntax error in FROM clause".

[glat]

I have however put the code in an unbound text box as

=IIf(Not IsNull([TenantRef]),[TenantRef],IIf(Not IsNull([FileListID]),[FileListID],Nz([AdminRef])))

and it works perfectly.

I have also used same code in another unbound text box for other fields as well.

Thank you for all your help.

[NeoPa]

Glat:
I tried your Nz option however all I kept getting was #Type in my text box.

I must have missed this earlier.

I'm confident that using Nz() should both work and give you what you asked for. Can you post your exact attempt at following the suggestion. I suspect we may be able to help you resolve it. One thing to bear in mind using Nz() is that the type of value to use if Null is important in most cases.

Now I've caught up with the rest of the posts I can see you may not be interested in following up any longer. That's fine, but if you want to see it done with just Nz(), which would be quite sensible, then feel free to continue on.

I would guess you want something like :

=Nz([TenantRef],Nz([FileListID],Nz([AdminRef],'')))

If at least one of them is always guaranteed to be non-null then even :

=Nz([TenantRef],Nz([FileListID],[AdminRef]))

[glat]

Neopa, somehow I did not receive your last reply. I tried your

=Nz([TenantRef],Nz([FileListID],Nz([AdminRef],'')))

and this one did work for me as well.

Thank you.