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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't create a report from my query in Access 1
Access Access Report Works on One Machine but not Another 3
Can I call a function in query criteria? 4
AND query 4
Help prevent report from running 1
Error message in report 1
Grouping Expression 2
One query for report and Excel 3

Back
Top