SQL Error

K

Kelly

Does anyone know why I get the following error? The
specified field () could refer to more than one table
listed in the FROM clause of your SQL statement?
 
M

mdas

You have a field called, say, "Field1" and that field name exists in 2 or
more of the tables in the SQL statement. The statement only includes the
name of the field, not the name of the table and field

You'll have to refer to the table and field name, ie.
[table1].[field1] instead of just [field1]

hth,
-M
 

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

Excel does not accept text format! 0
MS Project - error message when checking "Critical tasks" 1
Reference to more than one table 5
Help creating a search form in Access XP 0
Incone & Expenses Statement 0
System Error &H8007007E (-2147024770). The specified module could not be found. 0
Designate font as italic of another 0
Problem with complex sql statement underlying a form 1

Top