Union qry- results show #'s not words
- From: sooz9 <sooz9@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 2 May 2008 16:57:09 -0700
I reached a roadblock on my current database. I have multiple tables for
data entry for each type of product we run. For example, product Crag 4/6
has it's own table of data entry and Island 4/6 has it's own. Each product
has it's own lookup table of flavors depending on the product. Craig 4/6 has
it's own flavor list and so on. These flavors have a unique ID. I used a
union querry to combine all the different types of flavors to one list.
I then made a union qry to combine al the data from all the different
product mixes so I could use this qry to run reports and so forth. The
problem is the Union qry (that combines all the data from all the tables)
shows my ID numbers not the test of what the flavor is.
SQL from Union qry= combines all the tables data
SELECT *
FROM [YTD Craigmont 6 pack Log] <--( a qry producing calculated data)
UNION SELECT *
FROM [YTD Island 6 pack Log]; <--( a qry producing calculated data)
(this qry produces the ID for flavors not the words)
My table that has all the flavors is called "All Flavors"
How can I get the SQL to report the flavors as the test not the ID
.
- Follow-Ups:
- Re: Union qry- results show #'s not words
- From: Jeff Boyce
- Re: Union qry- results show #'s not words
- Prev by Date: Re: Function in Query
- Next by Date: Re: Union qry- results show #'s not words
- Previous by thread: default query result
- Next by thread: Re: Union qry- results show #'s not words
- Index(es):
Relevant Pages
|
