Just a bit puzzled about query behaviour.
I have a table with field "test". In design mode it is indexed Yes (No Duplicates) and Required Yes.
I can successfully run this update query
UPDATE CDDisks SET MyTable.Test = [Test]-1;
But I cannot do this
UPDATE CDDisks SET MyTable.Test = [Test]+1;
Test Field is Datatype Number
Why is that ?
I have a table with field "test". In design mode it is indexed Yes (No Duplicates) and Required Yes.
I can successfully run this update query
UPDATE CDDisks SET MyTable.Test = [Test]-1;
But I cannot do this
UPDATE CDDisks SET MyTable.Test = [Test]+1;
Test Field is Datatype Number
Why is that ?
Last edited: