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.
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.