Re: Qry not pulling bound column problem

Tech-Archive recommends: Fix windows errors by optimizing your registry

sorry, it is hard to explain what you don't understand.

both tables have data about products that are on hold. They are on hold for
totally different reasons, thus why 2 tables. I'm trying to create one
report that tells me everything in the building on hold and why, thus why I'm
trying to pull information from both places.

I did set up each table with the look up wizard so when filling out the form
you select from the combobox, This is set up in both tables.

Then what I did was make a query off each table to pull just the "hold"
product info I needed, then I wrote the Union qry to pull the data from each
of the other 2 queries so the info is together for the report.

Where I ended up was that everything worked perfect and I got teh info
needed with the exception that the Union qry is reporting #s instead of text.


So, hopefully to answer your question is that programmatically the tables
are not related at all, functionally however they both have data I want in
one report.

I hope this explains the background better and helps you to assist.

Thank you.

"John W. Vinson/MVP" wrote:


"AJ" <AJ@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E5B86479-DA0A-40B2-B6AB-897CE33B74A2@xxxxxxxxxxxxxxxx
I need the Union Qry... or so I think I do because... to use Jeanette's
example I am pulling...

select Tablex.fieldA,tablex.fieldB from Tablex
union
select tabley.fieldA,tableY.fieldB from TableY

to get 2 fields.

What are TableX and TableY? How (if at all) are they related? What do they
have to do with the rowsource of a combo box? What is the query mentioned in
your original post?

The UNION query will show ALL records in TableX and ALL records in TableY,
with no relationship between them; if FieldA is the ID and FieldB is the
description text, I don't see how this query is relevant to your original
post (which I understood to be about a Combo Box in a query data***).



.

Quantcast