Insert or Update column with stupid names

[phunction]

Hi, I have a database that I need to run an SQL query insert/update on, the problem is that the columns are actually named VALUE and PERCENT, Access complains about a syntax error anytime I try to do anything with this table, how do I run a query against it?



Thanks

[davegri]

Try putting square brackets around the problem names, e.g. [VALUE]

[CJ_London]

better still, change the column names to ones that are more meaningful in context - e.g. SaleValue, PCofTotal, whatever

[phunction]

Try putting square brackets around the problem names, e.g. [VALUE]

Ahh yes, I totally forgot about those, thanks.

[phunction]

Normally yes, but it was designed by someone else and I can't change it as all I do is update the data for them and they won't make the change.