Union Query and ID numbers!

[Ella1981]

Hi All,

I have just designed my first union query using help from various web sources. However, I seem to have run into a problem caused by my lack of database design experience.

I have used two different lookup tables which in the single queries, work perfectly. However, when I run the union query I get the ID numbers rather than the corresponding text.

I have since read up on this and appreciate that it is due to the use of lookup fields. I have also read that rather than getting rid of the lookup, I can change the SQL code to incorporate the relevant tables.

How do I do this and what is the syntax?? One table is called 'Assessors List' and has two fields 'ID' and 'AssessorID' (which is a person's name), the other is called 'Placement List' which has two fields 'ID' and 'Placement' (The name of a place of work). I want the person's name and the place of work to appear in the union query as they do in the original queries that form the union query.

Can someone please give me a step by step guide in how I bring in these tables??

Thanks in advance

Ella

 

[ariansman]

Many ones here disapprove loock-up. I have no idea as i don't have much experience about access.
However, i think you can run a select query on the Union query to extract and show the names instead of the IDs.