Calculated fields

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

Guest

Access 2003

I'm trying to build a query where the two tables I am using have a common
field and I need a calculated field. I need to identify in the calculation
which table the field is referencing and I can't remember how.

Help?
 
You need to qualify the field name with the table name.

SELECT Table1.Field1, Table2.Field2
FROM Table1, Table2;
 
Back
Top