syntax error- missing operator

[Bonk]

strSQL="SELECT DISTINCT eeg.Area_Of_Interest, eeg_Ecological_Group FROM Entomologist_Ecological_Group eeg, Area_Of_Interest ai WHERE eeg.Area_Of_Interest=ai.Area_Of_Interest AND eeg.Unique_Id="& objECI("Unique_Id") & " AND eeg.Ecological_Group="& objECI("Ecological_Group")

I get the following error for this line of code- can anyone help?:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'eeg.Area_Of_Interest=ai.Area_Of_Interest AND eeg.Unique_Id=126 AND eeg.Ecological_Group=Forest soil arthropods'.

 

[culshaja]

It lokks like you haven't delimited the string value.
Try the following:

strSQL="SELECT DISTINCT eeg.Area_Of_Interest, eeg_Ecological_Group FROM Entomologist_Ecological_Group eeg, Area_Of_Interest ai WHERE eeg.Area_Of_Interest = ai.Area_Of_Interest AND eeg.Unique_Id = "& objECI("Unique_Id") & " AND eeg.Ecological_Group = '"& objECI("Ecological_Group") & "';"

James
James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305