SQL problem -end of statement expected

[johnuk4]

hi,
Im sure this is really easy but i have a very limited knowledge of programming unfortunately. Basically iv got my sql string as follows:

SQLStr = "SELECT Hardware.Hardware_Make FROM Hardware WHERE (((Hardware.Hardware_Type)="Printer"));"

but it gives the error when compiled "End of Statement Expected" Iv tried playing with it for some time and its getting really annoying as i cannot solve this error. I would love it if someone could possibly give some ideas as to what is wrong with the string.

thanks johnuk4

 

[Don Delegate]

Use single quotes for literals in SQL statements.

E.g. 'Printer'

 

[johnuk4]

Thanks for the advice, much appreciated