Calculated fields

Y

yakdog

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

Darren Bartrup

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

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