The specified field name could refer to more than one table listed in the from clause of your SQL statment
From: Leasha (anonymous_at_discussions.microsoft.com)
Date: 04/28/04
- Next message: Leasha: "pop-up form to filter report"
- Previous message: Leasha: "Report Orientation"
- In reply to: Alan K: "The specified field name could refer to more than one table listed in the from clause of your SQL statment"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 27 Apr 2004 17:09:23 -0700
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?
>
>Any ideas?
>.
>
- Next message: Leasha: "pop-up form to filter report"
- Previous message: Leasha: "Report Orientation"
- In reply to: Alan K: "The specified field name could refer to more than one table listed in the from clause of your SQL statment"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
