December 10th, 2002, 02:20 PM
Querying Access gives me an Syntax error...please help
Here is my sql statement and error message:
Can I have a field name start with a number?
SELECT * FROM materials LEFT OUTER JOIN scndry_authors ON
materials.245_title_statement ='STUDY GUIDE TO ACCOMPANY
Warning: Invoke() failed: Exception occurred. Source: Microsoft
OLE DB Provider for ODBC Drivers Description: [Microsoft][ODBC
Microsoft Access Driver] Syntax error in query
expression 'materials.245_title_statement ='STUDY GUIDE TO
ACCOMPANY BIOLOGY.''. in
C:\tent\wwwroot\test\archives_catalog\result.php on line 71
Every man is a fool for at least five minutes every day; wisdom consists of not exceeding the limit.-- Elbert Hubbard
December 12th, 2002, 07:16 AM
It would seem that you can't start a field name with a number. I just tried it and it gave me a syntax error just like you got. When I changed the number to a letter, there was no error.