Calculated field in a Query using IIF & OR DLOOKUP

[cornforth]

I have created a query where one of the fields was created using the Lookup Wizard when the main table was constructed. I now wish to create a calculated field using one of these fields. I can get the query to run but the calculated field only shows the "ID" column and not the second column showing the text of the second table.
The result is the same for both Dlookup & IIf

Cand anybody help

 

[plog]

Can you demonstrate your issue with data? Provide 2 sets:

A. Starting data from your table. Include table and field names and enough data to cover all cases.

B. Expected results of A. Show me what data you hope to end up with if you feed your query the data in A.