Solved: SQL error

[lifeson]

I am having trouble ( as usual ) with the following

I am using excel to extract records from an access database and have got stuck with the following

[vba]Src = "SELECT TblAddress.AddressType, _
TblAddress.LeadNumber, _
TblAddress.Title, _
TblAddress.LastName, _
TblAddress.AddressLine1, _
TblAddress.PostCodeIn, _
TblAddress.PostCodeOut FROM TblAddress _
WHERE (((TblAddress.AddressType) = "I")) _
WITH OWNERACCESS OPTION;"[/vba]

I am getting a sytax error
I don't think I've got the line wrapping right and when I put it all on one line, (((TblAddress.AddressType) = "I")) causes a problem aswell

Any help greatly appreciated.

[rory]

Try:
Src = "SELECT TblAddress.AddressType, " & _
"TblAddress.LeadNumber, " & _
"TblAddress.Title, " & _
"TblAddress.LastName, " & _
"TblAddress.AddressLine1, " & _
"TblAddress.PostCodeIn, " & _
"TblAddress.PostCodeOut FROM TblAddress " & _
"WHERE (((TblAddress.AddressType) = 'I')) " & _
"With OWNERACCESS OPTION;"

[lifeson]

Thanks Rory
I tried the single quote rather than double quotes which solved the problem with the variable but I couldn't solve the multi line
Thanks

[rory]

Did you put in the '&' at the end of each line too? Works fine for me.

[lifeson]

Did you put in the '&' at the end of each line too? Works fine for me.

Sorry
Yes it does work
What I meant was, yes, you gave me the solution for the multiline which I couldn't work out, but I had worked out the single quote marks around the variable before you replied

Thanks again