fix the expression

[tubar]

How do I fix this to specify each table
Description: [level] & " " & [room] & " " & IIf(IsNull([direction]),[location],[direction] & " " & [location] & " " & [fixture] & " " & [note])


Description: [level] [level table] & " " & [room] [room table] DOESNT WORK

HELP

 

[namliam]

[tablename]![Columnname]

Hope that is what you are asking