Would someone please be so kind to tell me how to handle a field name with spaces!<sigh>
I'm trying to connect to a client's DB and they used spaces in their field names. I've tried a dozen combinations and I keep getting a syntax error. gstrSQLQuery = "SELECT * FROM tbl_client WHERE Client Last Name = '" & strLName & "'" I end up with Run-time error '-2147217900 (80040e14)': Syntax error (missing operator) in query expression 'Client Last Name = 'chapman''. I've tried quotes all over the place and can't get the @#$%^! thing right. TIA... Dian ~ -- This email scanned and certified clean by AVG! Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.7.3 - Release Date: 3/15/2005 --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [email protected] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
