Run Query error

  • Thread starter Thread starter Adrienne
  • Start date Start date
A

Adrienne

I tried to run a make table query and I'm receiving the
following error message:

The specified field [PROG_CLASS_CODE] could refer to more
than one table listed in the From clause of your SQL
Statement.


I used the help but I don't understand???
How should I correct the above error?

Thanks in advance for your help!
 
Your query has several tables, two tables containsfields
that have the same name. You need to rectify that by
going to desing view of the query and add the name of the
table you want that field to come from; ie. YourTableName!
[PROG_CLASS_CODE]

Hope that helps...
Gina
 
It's not working where should the below information be
placed. I'm still showing an error?? Keep in mind I'm in
the query portion of a MAKE TABLE query as a result of the
ODBC (data). Which means the field names are
automatically set up based on the ODBC. Please advise!!



-----Original Message-----
Your query has several tables, two tables containsfields
that have the same name. You need to rectify that by
going to desing view of the query and add the name of the
table you want that field to come from; ie. YourTableName!
[PROG_CLASS_CODE]

Hope that helps...
Gina
-----Original Message-----
I tried to run a make table query and I'm receiving the
following error message:

The specified field [PROG_CLASS_CODE] could refer to more
than one table listed in the From clause of your SQL
Statement.


I used the help but I don't understand???
How should I correct the above error?

Thanks in advance for your help!
.
Click to expand...
.
Click to expand...
 
Back
Top