same field name multiple tables

[steve wills]

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

 

[CJBIRKIN]

Hi

Have you tried using the name of the table as a prefix i.e

[tbl_A].[Price]*[tbl_B].[Price]


Chris

 

[steve wills]

Chris

your a good man. Dont know why i didnt think of that.

Thanks

Steve

 

[CJBIRKIN]

No worries

 

[Pat Hartman]

If you alias the names, you'll have less trouble with forms/reports/VBA.

Select tbl1.Price As OurPrice, tbl2.Price As TheirPrice, .....