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;
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count text values in a Access Field 0
Query Field Using Other Fields in the Query 3
Summing multiple fields 2
Aggregate calculations on calculated query fields? 6
Overflow error on calculate field in query - Help Please 1
Using a Yes/No field to trigger a calculation in another field - J 3
Split data in field on character return 0
Complicated Calculated Field Logic 0

Back
Top