Help with error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report based on a query. I can run the query without a probme and I
can run the report without a problem. When I created a form with a combo to
run the same report I keep on getting "The specified field...could refer to
one or more table listed in the FROM clause of your sql statement." The field
does not exist on the report, but is on the query. I have checked the
properties of the report and the field is not on the filter or the sorting
and grouping optipns. Where else could it be?
 
Look at your query. You have two or more tables included in your query and
one of the fields in your query has a name that appears in more than one
table. Consequently, Access doe not know which table to use to get the data.
Type in something like MyTable.MyFieldName to point Access to the table you
want it to pull data from.
 
Back
Top