Connie-
You have an extra close paren on this line:
& "ON City_List.CityID = HomeInfo.CityID) " _
It should be:
& "ON City_List.CityID = HomeInfo.CityID " _
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
------------------------------
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of mrsgoudge
Sent: Tuesday, May 08, 2012 6:42 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [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 & ";")
Selasa, 08 Mei 2012
RE: [MS_AccessPros] Syntax error in From clause
__._,_.___
.
__,_._,___
Langganan:
Posting Komentar (Atom)
Tidak ada komentar:
Posting Komentar