Linking Queries from same table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 3 queries that have identical fields but calculate fields differently
and do not have the same names in them. How can I get these to join into on
query to base a report on?
 
Hi, Jess,

In your SQL, prefix each field name with the table name, as follows: Table1.
Field1Name, Table2.Field1Name

This will keep your fields unique.

Sam
 
Just set up a new query, add all 3 of them, link the key field(s), and pick
which fields you want. Access will take care of the SQL.
 
Back
Top