Union query results

[paul1707]

Hi all,

I am just learning and have only been using access seriously for a couple of weeks. (Please be gentle)

I have got two tables and generated a union query. All is good and there are no problems and i understand the concept which works well.

What i don't understand is why a standard query returns the valus as is and the union query returns record numbers instead on values.

Can someone help me understand? I would like to just report of the union query but it has no relevance if it's only numbers.

Thanks in advance

 

[gemma-the-husky]

are you referring to values returned by lookups within your tables?

 

[paul1707]

are you referring to values returned by lookups within your tables?

Yes thats right, it only seems to be them, if the data is entered it shows correctly.

Thanks

 

[gemma-the-husky]

because a union query is in sql, which presumably gets the real data in the tables not the referenced value

in point of fact, most advisors here would tell you to avoid using lookups in tables precisely for that reason - it is far better to see the real data THAN the referenced data.

 

[paul1707]

Thank you for that, have you got an idea on how i could then report on the 2 separate tables. The output needs to go on the same report and the job numbers from each table indexed but duplicates are ok.

Thanks again