SQL error specified filed could refer to more than one table.

[Windsorcat via AccessMonster.com]

The error I am getting: The specified field'[dbo_tblClient].dbo_tblClient!
Name_Last' could refer to more than one table listed in the FROM clause of
your SQL statement.

SQL Statement:
SELECT DISTINCT dbo_tblClient.ClientID, [dbo_tblClient].dbo_tblClient!
Name_Last & ", " & [dbo_tblClient]![Name_First] & " " & [dbo_tblClient]!
[Name_Middle] AS Name, dbo_tblClient.Date_Of_Birth, [Qry:Address].Street,
dbo_tblRef_Offense_Code.Description, [Qry:Agent].[dbo_tblSystem_User.
Name_First] AS Expr1, [Qry:Agent].[dbo_tblSystem_User.Name_Last] AS Expr2,
dbo_tblAddresses.City, dbo_tblCase_Status.Case_ServiceID
FROM (dbo_tblRef_Offense_Code INNER JOIN ((((([Qry:Agent] INNER JOIN
dbo_tblClient ON [Qry:Agent].ClientID = dbo_tblClient.ClientID) INNER JOIN
[Qry:Address] ON dbo_tblClient.ClientID = [Qry:Address].ClientID) INNER JOIN
dbo_tblClient_Cases ON (dbo_tblClient.ClientID = dbo_tblClient_Cases.ClientID)
AND (dbo_tblClient.ClientID = dbo_tblClient_Cases.ClientID)) INNER JOIN
dbo_tblCase_Status ON dbo_tblClient_Cases.CaseID = dbo_tblCase_Status.CaseID)
INNER JOIN dbo_tblCase_Offenses ON dbo_tblClient_Cases.CaseID =
dbo_tblCase_Offenses.CaseID) ON dbo_tblRef_Offense_Code.Offense_CodeID =
dbo_tblCase_Offenses.Offense_CodeID) INNER JOIN dbo_tblAddresses ON [Qry:
Address].AddressID = dbo_tblAddresses.AddressID
WHERE (((dbo_tblAddresses.City)="apple valley" Or (dbo_tblAddresses.City)
="farmington" Or (dbo_tblAddresses.City)="lakeville" Or (dbo_tblAddresses.
City)="rosemount" Or (dbo_tblAddresses.City)="burnsville" Or
(dbo_tblAddresses.City)="hastings" Or (dbo_tblAddresses.City)="mendota
heights" Or (dbo_tblAddresses.City) Like "SO* ST PAUl" Or (dbo_tblAddresses.
City) Like "We* st paul" Or (dbo_tblAddresses.City)="eagan" Or
(dbo_tblAddresses.City) Like "inver*" Or (dbo_tblAddresses.City) Like
"northf*") AND ((dbo_tblCase_Status.Case_ServiceID)=3 Or (dbo_tblCase_Status.
Case_ServiceID)=4 Or (dbo_tblCase_Status.Case_ServiceID)=6 Or
(dbo_tblCase_Status.Case_ServiceID)=17 Or (dbo_tblCase_Status.Case_ServiceID)
=18 Or (dbo_tblCase_Status.Case_ServiceID)=19 Or (dbo_tblCase_Status.
Case_ServiceID)=20 Or (dbo_tblCase_Status.Case_ServiceID)=21 Or
(dbo_tblCase_Status.Case_ServiceID)=22 Or (dbo_tblCase_Status.Case_ServiceID)
=23) AND ((dbo_tblClient.Adult_Juvenile_Indicator)="a") AND (
(dbo_tblCase_Status.Case_StatusID)=1) AND ((dbo_tblCase_Status.End_Date) Is
Null) AND ((dbo_tblCase_Offenses.Offense_CodeID)=162 Or (dbo_tblCase_Offenses.
Offense_CodeID)=163 Or (dbo_tblCase_Offenses.Offense_CodeID)=164 Or
(dbo_tblCase_Offenses.Offense_CodeID)=165 Or (dbo_tblCase_Offenses.
Offense_CodeID)=166 Or (dbo_tblCase_Offenses.Offense_CodeID)=167 Or
(dbo_tblCase_Offenses.Offense_CodeID)=168 Or (dbo_tblCase_Offenses.
Offense_CodeID)=169 Or (dbo_tblCase_Offenses.Offense_CodeID)=170 Or
(dbo_tblCase_Offenses.Offense_CodeID)=171 Or (dbo_tblCase_Offenses.
Offense_CodeID)=172 Or (dbo_tblCase_Offenses.Offense_CodeID)=173 Or
(dbo_tblCase_Offenses.Offense_CodeID)=174 Or (dbo_tblCase_Offenses.
Offense_CodeID)=175 Or (dbo_tblCase_Offenses.Offense_CodeID)=372 Or
(dbo_tblCase_Offenses.Offense_CodeID)=373 Or (dbo_tblCase_Offenses.
Offense_CodeID)=374 Or (dbo_tblCase_Offenses.Offense_CodeID)=344 Or
(dbo_tblCase_Offenses.Offense_CodeID)=395) AND (([Qry:Address].
Physical_Address)=True));

I know this is horrible to look at, but does anybody have any ideas for me?

Thanks

 

[Marshall Barton]

The error I am getting: The specified field'[dbo_tblClient].dbo_tblClient!
Name_Last' could refer to more than one table listed in the FROM clause of
your SQL statement.

[snip mind numbing SQL statement]


[dbo_tblClient].dbo_tblClient!Name_Last

is invalid syntax.

Shouldn't that be:

dbo_tblClient.Name_Last

Note that the ! sybtax is nonstandard, you should use dot.