Results 1 to 2 of 2

Thread: adding

  1. #1
    Join Date
    Dec 1969

    Default adding

    I want to add 1 to a number in an Access db each time the record is updated. I know this doesn&#039t work but don&#039t know how else to do it. I even tried the field name +1 but couldn&#039t get the syntax right.<BR><BR>Can anyone lead me in the right direction? Thanks!<BR><BR>sqlstmt = sqlstmt & "updates= &#039+1&#039"

  2. #2
    Join Date
    Dec 1969

    Default RE: adding

    Update TableName Set CounterFieldName =CounterFieldName + 1

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts