DoCmd.RunSQL and parentheses in field name

[th2002]

Hi!

Table name: Table1
Field name: OrderNumber(AutoNumber)

I need to run SQL using this field name and now parentheses in the name is giving me hard times.

DoCmd.RunSQL "DELETE * FROM Table1 WHERE OrderNumber(AutoNumber) LIKE " & intNumber & " ;"

This statement would work if there wasn't parentheses in the name. Is there someway to use parentheses in that kind statement? It's too late to change the field name...

Thanks if somebody has an answer to this!

-TH-

 

[KenReay]

Hi

DoCmd.RunSQL "DELETE * FROM Table1 WHERE [OrderNumber(AutoNumber)] LIKE " & intNumber & " ;"

should work

and let this be a lesson in naming of columns and other objects

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
kenneth.reaySPAMNOT@talk21.com
remove SPAMNOT to use