Qry not pulling bound column problem

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.

Then I have a Union query to pull the 2 above together. This one returns
column(0) not column(1) as I need. If you ask why I do the queries this
way... only way I know how... sorry.

I'm not sure posting my code helps at this point.

Thanks to anyone who can help, it is greatly appreciated.

Thank you,

.

Relevant Pages

  • RE: *REPOST* Select Records based on 2 dates
    ... Why not just use only the disposition date? ... Clifford Bass ... suggested and then do a union query to put them together. ...
    (microsoft.public.access.queries)
  • Re: union qry problem
    ... Select * from 2007 qry ... Hash: SHA1 ... Don't use the * in a UNION query - you ...
    (microsoft.public.access.queries)
Loading