Using Union query in form

S

Sharon

I am using Access 2003 and I have created a union query for a field named in
the union query as ReferenceNo. The union query consists of one field from
each of the below tables:
TableAReferences, USPatentNo, LastName, Date,
TableBReferences, ForeignPatentNo, Date, Country
TableCReferences, OtherReferenceNo, Author, Title, Date

Now, I want to create a query that includes:
ReferenceNo (from the union query)
LastName, Date, Country
Country, Author, Title

in other words, I want a query showing all the data for each type of
reference, but I want them all in one query so I can use them on forms and
subforms.

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top