return column to defaults

Results 1 to 2 of 2

Thread: return column to defaults

  1. #1
    Join Date
    Dec 1969

    Default return column to defaults

    I would like to trun one col in my database to the default value. Col name is active and the default value is No<BR><BR>Thanks<BR>Stephen

  2. #2
    Join Date
    Dec 1969

    Default UPDATE table SET active=False

    I assume this is an Access table, and that active is a Yes/No field. If so, Access lies to you. That&#039;s actually a *boolean* field, so the conventional values to use are True and False, instead of Yes and No.<BR><BR>UPDATE table SET active=False<BR><BR>That will change *all* records in that table to have False (which Access reports will show as No) in the "active" field.<BR><BR>

Posting Permissions

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