Incrementing value on update problem

[Microbe]

I am updating a table in Access. I have a "counter" that keeps track of a condition.

When I use the following SQL statement:

strSQL = "UPDATE Users SET "
strSQL = strSQL & " user_AccessLevel_ID = 4 "
strSQL = strSQL & ", user_numberofProfiles = " & (user.fields.item("user_numberofProfiles&quot.value + 1)
strSQL = strSQL & " WHERE "
strSQL = strSQL & " User_Login ='" & session("user_Login&quot & "'"

it works fine if the initial value is 0 (zero), incrementing user_numberofProfiles to 1, but from then on, although it updates other fields, no go on the numberofProfiles.

I know it is something wrong with - user.fields.item("user_numberofProfiles&quot.value - but it looks fine.

Any ideas?

Thanks in advance

Steve Davis
hey.you@hahaha.com.au

http://www.hahaha.com.au

 

[Microbe]

addendum...

Actually the increment from 0 to 1 only works if I have
strSQL = strSQL & ", user_numberofProfiles = " & user_numberofProfiles + 1

But that doesn't look right because it isn't actually getting the field value. But why does it change the value if it is zero?

...puzzled...

Steve Davis
hey.you@hahaha.com.au

http://www.hahaha.com.au