So simple--thanks!
--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...> wrote:
>
> 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 & ";")
>
Tidak ada komentar:
Posting Komentar