Union Queries

[spatel]

I need to link three quiries together and display their ouput in a report.

However, some field names are different so how do you write a union query that'll link all 3 query.

I think you have to create an alias and use the alieas to write the quiery, but I am not sure..

Can anyone help..

 

[Norie]

Why do you need a UNION query?

Do the fields in the queries/tables hold the same type of data but just have different names?

 

[spatel]

Well, I though you have to create a UNION qry in order to link the queries together. Don't you

The data in the fields is same, so thats shouldn't matter..

 

[Norie]

Is there a common field that links the queries? eg ID

From help

UNION

Creates a union query, which combines the results of two or more independent queries or tables.