V
vispute pramod
In query I am getting folloiwng error.
The specified field <field> could refer to more than one
table listed in the FROM clause of your SQL statement.
(Error 3079)
==============
I design query having 3 link tables, with duplicates
fields, orderby and filter criteria in Access 97. Above
error clearly state the problem. In query design mode, I
tried to replace the field name with [tablename].
[fieldname]. Still gives the same error.
The specified field <field> could refer to more than one
table listed in the FROM clause of your SQL statement.
(Error 3079)
==============
I design query having 3 link tables, with duplicates
fields, orderby and filter criteria in Access 97. Above
error clearly state the problem. In query design mode, I
tried to replace the field name with [tablename].
[fieldname]. Still gives the same error.