Re: Union qry- results show #'s not words

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Tbl Craig 4/6
ID- number
Flavor- test

Tbl Caig 4/6 Log
Date
Flavor- Look-up tbl Craig 4/6 for a drop down a different flavors
Filler speed- number
cases per hour- number

Tbl Island 4/6
ID- number
Flavor- text

Tbl Island 4/6 Log
Date
Flavor- Look-up tbl Island 4/6 for a drop down a different flavors
Filler speed- number
cases per hour- number

The database has other product types and flavors in it but if I can get it
to work for 2 then I can get it to work for more. The purpose of the
database is to track the performance of different flavors we run each day
etc.

"Jeff Boyce" wrote:

Hold on a sec...

You have tables specific to each product? That sounds like a spread***,
not a relational database.

Please provide an example of your table(s) (such as a table name, field
names, example data in fields).

Regards

Jeff Boyce
Microsoft Office/Access MVP


"sooz9" <sooz9@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FC37367E-FA15-43B5-8F81-E0463F8C56ED@xxxxxxxxxxxxxxxx
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




.

Quantcast