J
Justin83716
When I use the critieria [Last Name] in my WHERE clause
I receive the runtime error 3079
"The specified field '[Last Name]' could refer to more than one table listed
in the FROM clause of your SQL statement.
I will not post the whole SQL statement here unless it is needed, but I have
looked at it, and there is NOT a [Last Name] in more than one table. The only
table with a field [Last Name] is tblEmployeeData. So I modifed my WHERE
criteria to specifiy the specific table and specific field
(tblEmployeeData.[Last Name]) However, this does not seem to make a
difference. I still get the runtime error.
Does anyone have thoughts on why I get this error even when there appears to
be no other table with the specific field.
Thanks!
I receive the runtime error 3079
"The specified field '[Last Name]' could refer to more than one table listed
in the FROM clause of your SQL statement.
I will not post the whole SQL statement here unless it is needed, but I have
looked at it, and there is NOT a [Last Name] in more than one table. The only
table with a field [Last Name] is tblEmployeeData. So I modifed my WHERE
criteria to specifiy the specific table and specific field
(tblEmployeeData.[Last Name]) However, this does not seem to make a
difference. I still get the runtime error.
Does anyone have thoughts on why I get this error even when there appears to
be no other table with the specific field.
Thanks!