I'm writing a Database program and using MS Access with SQL statements doing the dirty work. I have reading, adding new records and deleting records done working, and awesome. But when it comes time to update payment info I have a problem.
This SQL statement works :
UPDATE Books SET Camper_Last='Doe',Camper_First='JOHN' WHERE Camper_Last='Doe' AND Camper_First='John' AND Event_Year='2010'
Where this one gives me an SQL Syntax Error:
UPDATE Books SET Final Event Cost='0' WHERE Camper_Last='Doe' AND Camper_First='John' AND Event_Year='2010'
I know everything before SET and after WHERE is ok, Final Event Cost is a Text Field of unlimited length. I slept on it and think its the spaces in the field name, but I'm hours away from being able to open it up and try that out, so in the mean time I wanted to post here just to make sure it wasn't anything else.
Any input is much appreciated, vbdotnetforums is where I have gone from the start. Love this place and have got many helpful responses in the past. Thanks for any help and I hope your having a good day!
Nick
This SQL statement works :
UPDATE Books SET Camper_Last='Doe',Camper_First='JOHN' WHERE Camper_Last='Doe' AND Camper_First='John' AND Event_Year='2010'
Where this one gives me an SQL Syntax Error:
UPDATE Books SET Final Event Cost='0' WHERE Camper_Last='Doe' AND Camper_First='John' AND Event_Year='2010'
I know everything before SET and after WHERE is ok, Final Event Cost is a Text Field of unlimited length. I slept on it and think its the spaces in the field name, but I'm hours away from being able to open it up and try that out, so in the mean time I wanted to post here just to make sure it wasn't anything else.
Any input is much appreciated, vbdotnetforums is where I have gone from the start. Love this place and have got many helpful responses in the past. Thanks for any help and I hope your having a good day!
Nick