Union Query Results

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DCH - 11 Jul 2007 01:54 GMT

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.

Reply to this Message

John W. Vinson - 11 Jul 2007 02:06 GMT

>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
[quoted text clipped - 3 lines]
>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]

Reply to this Message

DCH - 12 Jul 2007 02:02 GMT

Thank you John!!

> >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
[quoted text clipped - 13 lines]
>
> John W. Vinson [MVP]

Reply to this Message