How to make a concantenated field pick up the detail rather than the ID of a field

[Tennotrumps]

Hi - I am running a query (to use for a report) where in several instances I concantenate the data from 2 or 3 separate fields into one. For some reason, where the original filed is populated by lookup from another table in some (but not all) of these "joined" fields it brings in the record ID rather than the details I have requested.

Any ideas?

I am using Access 2007

[beacon]

Can you post the SQL for the query and maybe an example of the output?

[nico5038]

Guess you need to put the DLOOKUP into your query to get the data iso the ID.

Did you try that ?

Nic;o)

[Tennotrumps]

Can you post the SQL for the query and maybe an example of the output?

I am really new to this - not sure what you are asking

[Tennotrumps]

No - can you give me an example of how to do this please?

[nico5038]

Just place the DLOOKUP as (defined in the table for the field) instead of the field in a SELECT statement and use the field/table in the WHERE parameter to get the data from the other table.

Another option is to add the related table and JOIN by the field to get the description from the other table.

Nic;o)

[beacon]

If you still want to post the SQL, open the query, go to View, then choose SQL View.

Did you have an example of the data you want to appear and an example of what is actually appearing?