Selasa, 08 Mei 2012

[MS_AccessPros] Syntax error in From clause

 

Good morning!

Would you take a gander at this to see what's giving the "syntax error in from clause" message? I know I should be able to figure it out but have had no luck.

Thanks!
Connie

Set rstSt = db.OpenRecordset("SELECT HomeInfo.Nbr, HomeInfo.Direction1, " _
& "Street_List.Street, HomeInfo.Direction2, City_List.City, HomeInfo.StreetComb " _
& "FROM City_List INNER JOIN " _
& "(Street_List INNER JOIN HomeInfo ON Street_List.StreetID = HomeInfo.StreetID) " _
& "ON City_List.CityID = HomeInfo.CityID) " _
& "WHERE HomeInfoID = " & Me.HomeInfoIDHeader & ";")

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar