Field Name Error within table

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?
 

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

Append Crosstab Query to Existing Table 0
sqlite-odbc write conflict 2
design access 4
'Data Type Mismatch In Criteria Expression' error when using 'Count' in query Design; Help! 0
Spec. field ... could refer to more than one table ...SQL Statemen 11
Linking data in MS Word into Excel 5
Limit on number of fields in MS Access forms 3
Linking First & Last Names in a table to a Full Name field in anot 3

Top