Access question error

[LAURA HAUG]

Hello I have a report that keeps erroring on me. I have a relationship between two tables using only one link. This is the error I am getting when I try to run the report function.

The specified field 'County' could refer to more than one table listed in the From clause of your SQL statement.

Does anyone know what I need to correct to get this report to work. The funny thing is it work before and now it doesn't. I think someone changed something, however I am unsure what.

 

[Andrew Fergus]

Hello Laura

It sounds like one of the fields on the report is called "County" and the variable "County" is present in both tables so the report is confused as to which "County" to use. If this is the case then you can rename the variable from [County] to [TableName].[County] in the report (right click "County" -> Properties -> Control Source) which may fix the problem.

NB : remember to use your actual table name and not "TableName"

If this is not the case, can you supply some additional details about the 2 tables, what fields are in the tables and which 2 fields are linked?

HTH, Andrew.