S
steve wills
Guest
Hi Guys / Gals
Heres my prob
Just some info to start. I have 2 odbc linked tables for which i will not be able to change any names or properties.
The problem.
2 of the tables which i need to query have the same field name "price", the data in each of these fields will be different. I need to get both sets of "price" data into my query. access wont let me do this and sends up an error explaining that the "price" field is in both tables.
Thanks in advance for any help
Heres my prob
Just some info to start. I have 2 odbc linked tables for which i will not be able to change any names or properties.
The problem.
2 of the tables which i need to query have the same field name "price", the data in each of these fields will be different. I need to get both sets of "price" data into my query. access wont let me do this and sends up an error explaining that the "price" field is in both tables.
Thanks in advance for any help