Linking Queries from same table

J

Jessaudrey

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?
 
O

OfficeDev18 via AccessMonster.com

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
 
R

Rob Oldfield

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