The specified field name could refer to more than one table listed in the from clause of your SQL st

[Guest]

I am joining a couple of crosstab queries in a query which is the record source for a report

All of the queries run fine. However, the report is not generating data. The output is an error message that "The specified field name could refer to more than one table listed in the from clause of your SQL statment.

Problem is that the SQL statement in my queries do specify the table name (e.g. [table name].[fieldname]) so I am not sure how I can be any more specific

Any ideas?

 

[Leasha]

In your crosstab query use the 'expr1: original field'
format on the field row of your query grid to rename one
of the ambiguous field references. Call it whatever you
like but then you'll need to use that name in your report.
example:

field: fldChemicalName
Table: tblChemicals

change it like so:
field: fldChemName: fldChemicalName
Table: tblChemicals

Now in the join you will have fldChemicalName from one
query and fldChemName from the other query.

Good luck and I hope this helps.

-----Original Message-----
I am joining a couple of crosstab queries in a query

which is the record source for a report.

All of the queries run fine. However, the report is not

generating data. The output is an error message that "The
specified field name could refer to more than one table
listed in the from clause of your SQL statment."

Problem is that the SQL statement in my queries do

specify the table name (e.g. [table name].[fieldname]) so
I am not sure how I can be any more specific?