Kinger43
racecar driver
- Local time
- Today, 13:31
- Joined
- Aug 17, 2007
- Messages
- 226
I have a report based on a query. When I run the report I get a pop up that says "The specified field [FIELDNAME] could refer to more than one table listed in the FROM clause of your SQL statement. Is there some way that I can specify which table I want it to come from?
The field is already in the form TABLE.FIELDNAME. I think the problem is that the query the report is based on uses TABLE and two queries both based on TABLE.
The field is already in the form TABLE.FIELDNAME. I think the problem is that the query the report is based on uses TABLE and two queries both based on TABLE.
