By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,630 Members | 1,166 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,630 IT Pros & Developers. It's quick & easy.

Increment a table field value by 1 - SQL fails to do so

P: n/a
MLH
Can someone tell me what I'm doing wrong in this query?

UPDATE tblEventsSituationsIncidents SET
tblEventsSituationsIncidents.ES01 = [ES01]+1;

I'm trying to update the value in table field [ES01]
and am unsure why my SQL logic isn't doing it.
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
MLH
What a bozo! Am sorry. I didn't have a record
in the table. All the default field values were
zero. Opening the table, I mistook all the default
values showing zero as a record when there
really wasn't one. I ADDED one and the SQL
works fine. My mistake.
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.