Union Query Results

[Guest]

I have a Union Query combining the results of 5 Select Querys. It works
great accept for the Item Field (found in each Select Query), which is
returning it's numeric primary key, instead of the realated text Item Name.
The Select Querys return the text value. Any ideas?

Many Thanks,
David.

 

[John W. Vinson]

I have a Union Query combining the results of 5 Select Querys. It works
great accept for the Item Field (found in each Select Query), which is
returning it's numeric primary key, instead of the realated text Item Name.
The Select Querys return the text value. Any ideas?

Many Thanks,
David.

My guess is that the Select Queries are based on a table which uses the *very*
limited misfeature, Microsoft's Lookup Field. If so the table (and queries
directly based on the table) *appear* to contain the item name but actually do
not: they contain a concealed ID number instead.

You can either Join the Items lookup table to each of the five SELECT queries,
or join the UNION query to the Items table by the numeric key.

John W. Vinson [MVP]

 

[Guest]

Thank you John!!

My guess is that the Select Queries are based on a table which uses the *very*
limited misfeature, Microsoft's Lookup Field. If so the table (and queries
directly based on the table) *appear* to contain the item name but actually do
not: they contain a concealed ID number instead.

You can either Join the Items lookup table to each of the five SELECT queries,
or join the UNION query to the Items table by the numeric key.

John W. Vinson [MVP]