Re: Qry not pulling bound column problem

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.

I do need to pull info from these 2 queries together for a report, if there
is a way to to that and not use the union query I am more than happy to learn
that. I just need the text too.

Thank you


"John W. Vinson/MVP" wrote:


"AJ" <AJ@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FA8616B0-B2A7-4FD5-A328-957BE2FEED3A@xxxxxxxxxxxxxxxx
I have a qry where I pull records from a table. When I run this qry all is
fine, I get the bound column (1) returned which is the text I want not
the
primary key which is in column(0).
I do the same for another table... all is fine. Note these 2 were created
using the design view of Query... I'm not a programmer... just a chemist
trying to build a database.


Hi fellow chemist!

You're another victim of Microsoft's misfeature, the Lookup Wizard. Your
table and query APPEAR to contain the text... but they don't. The combo box
conceals the actual content of the table from view.

If you want to see the text, use a query joining your main table to the
lookup table and select the text from the lookup table (and, if you want to
see both the ID and the text, select the ID from either table). If you don't
want to see the text, just base the query on the main table, and use the
Lookup tab in the field properties of this field to change it from Combo Box
to Textbox, so you can see what is actually there. It is NOT necessary to
use a UNION query.



.

Relevant Pages

  • Re: Combining records from two queries
    ... combining UNION and SELECT queries to best effect. ... The list in each case has to have the same number & types of fields (for example, if the first Query begins with a Date/Time field, the second one should do so as well). ... I like to keep my Union Queries short and simple and do the rest of the work elsewhere. ... tblMentors comprises Subject Mentors and Professional Mentors and the Placement subform has a combo for each - the Subject Mentor combo puts the chosen MentorID in the SubjectMentorID field and the Professional Mentor combo puts the chosen MentorID in the ProfessionalMentorID field. ...
    (microsoft.public.access.queries)
  • Re: Graphical Union-Query Builder?
    ... If you are limiting the input in each of the sub-queries in your Union ... Use the filtered queries as the input to your Union query: ... Most "functional IT users" will not know anything about SQL. ... I didn't know that fields of subsequent queries in a Union could have ...
    (microsoft.public.access.queries)
  • Re: Help! Union Query has started crashing!
    ... It's tblSupport on the RLR_SUPPORT_INFOTERRA.mdb database. ... I think I have tracked the problem down to the query ... I also tried a UNION ALL, ... the actual structure of the queries as they have been running fine for weeks. ...
    (microsoft.public.access.queries)
  • Re: Sum of numbers
    ... "Evi" wrote: ... You say the union query 'only shows fields from the first table'. ... Do you mean that you want a multicolumn report with all customers' names ...
    (microsoft.public.access.reports)
  • Re: How to get a distinct count of result set of multople table joins?
    ... since the UNION syntax removes duplicate rows automatically. ...   "SORT " in your execution plan. ... The base query is an outer join. ...
    (comp.databases.oracle.misc)