Error: "...can refer to more than one field"?

  • Thread starter Thread starter Samuel S.
  • Start date Start date
S

Samuel S.

I created created a multiple-table query that also
incorporates other queries as criteria (in Access 2000).
All tables and queries are linked through a unique ID code
("primary key?"). Some of these links I had to create in
the relationships tab. As expected, the query produces
multiple records for a given ID code.

When I go to make a report and try to run it, I get a
message like:

"ID can refer to one or more fields"

and won't let me run the report. What does this mean?
What causes it? Can it be fixed?

I'm desperate, someone please help.

-Samuel
 
This message means that you have an expression that refers to a field in one
of your queires/tables where the name matches another query/table. For
example if you have a field called FirstName in Query1 and another field
FirstName in Query2, using an expression like FullName:[FirstName] & " "
&[LastName] will give an error since [FirstName] can refer to either Query1
or Query2. To avoid this, specifically identify the source
FullName:[Query1].[FirstName] & [Query1].[LastName] when you have identical
field names.

Kelvin
 
Back
Top