Apologies if this is double-posted.
I've tried the following SQL query (part of it taken from the help you guys were nice enough to give me) but it's throwing up an error, pointing to the 'by' (highlighted in bold - right at the end of my SELECT line):-
Is there anyway I can get this successfully formatted so it works OK
strSQL = "SELECT sculptures.ID, sculptures.Name, artist.Firstname, sculptures.condition, sculptures.literature1, sculptures.literature2, sculptures.literature3, sculptures.literature4, sculptures.ImageIndivMain, sculptures.articlenumber, sculptures.circadate, sculptures.Description, artist.Surname, sculptures.artistID, sculptures.weight, sculptures.price, sculptures.depth, sculptures.width, sculptures.height, literature.title & " by " & literature.author AS literaturecombine" & strCRLF & _
" FROM ((sculptures" & strCRLF & _
" INNER JOIN artist ON artist.NameURL = sculptures.artistID)" & strCRLF & _
" INNER JOIN literature ON literature.literaturecombine = sculptures.literaturecombine1)" & strCRLF & _
" INNER JOIN sculpturetype ON sculpturetype.TypeURL = sculptures.sculpturetypeID" & strCRLF & _
" WHERE sculptures.NameURL='" & lngRecord & "'"
Thanks for your help again