Syntax Error In Insert Into Statement

[John_G]

I may have found it (again) - another reserved word MS Access doesn't like as a field name- order



When I run your exact code using "order", I get the syntax error. But when I change it to "Order_Number", I get the errors I would expect, using my database like unknown field names (as it happens, I have a table called eventlog).


So, change "order" to something else, like you did with "date", and see what happens.

[ULMA]

Great John,
I just wrapped order in brackets [order] and it worked! Thank you so much! I will try the same with date and see if it will take it.
I know that I should not use those reserved words but these were there already and cannot change because of the many forms tied to them.
I really enjoyed chatting with you and again sorry for time.
ULMA

[June7]

I use Rick Fisher's Find & Replace add-in for global mods like changing a field name. Saved my sanity more than once.