If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Two Tables with the same field name
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? |
#2
|
|||
|
|||
Two Tables with the same field name
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 "tc" wrote in message ... 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? |
#3
|
|||
|
|||
Two Tables with the same field name
On Aug 24, 1:35*pm, "Graham Mandeno"
wrote: 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 "tc" wrote in message ... 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! |
Thread Tools | |
Display Modes | |
|
|