A
Allison
Help!!!
I added a field to my make table query. My query has four
different tables from an ODBC source. I also selected a
primary key. I'm receiving an error message when I try to
run the query:
The specified field [FULL_GRANT_NUM] could refer to more
than one table listed in the FROM clause of your SQL
statement.
My table name is tblCANPV(where the field is located);my
field name - NEW GRANT NUMBER.
How should I generate the Field Name?
I added a field to my make table query. My query has four
different tables from an ODBC source. I also selected a
primary key. I'm receiving an error message when I try to
run the query:
The specified field [FULL_GRANT_NUM] could refer to more
than one table listed in the FROM clause of your SQL
statement.
My table name is tblCANPV(where the field is located);my
field name - NEW GRANT NUMBER.
How should I generate the Field Name?