Two Tables with the same field name

[tc]

hi, i have two tables with different names; however, i have a field in
both these tables which have the same name. i need to calculate the
difference between the two fields. however, when i try to create a
query, i get a error message saying that there are multiple fields
with the same name. how do i overcome this problem?

 

[Graham Mandeno]

Hi TC

Add the table name to the field name so you have an unambiguous reference:

Difference: [Table1].[MyField] - [Table2].[MyField]

 

[tc]

Hi TC

Add the table name to the field name so you have an unambiguous reference:

Difference: [Table1].[MyField] - [Table2].[MyField]

--
Good Luck  

Graham Mandeno [Access MVP]
Auckland, New Zealand

hi, i have two tables with different names; however, i have a field in
both these tables which have the same name. i need to calculate the
difference between the two fields. however, when i try to create a
query, i get a error message saying that there are multiple fields
with the same name. how do i overcome this problem?

Thank you so much for your help!