-
April 1st, 2004, 09:48 AM
#1
Clearing every record in a field
I would like to place a button on my access form that would delete all data from a given field. I have a Yes/No field so I can flag various records, but I want to be able to clear them all in one swoop rather than clicking though hundreds of records on a query.
Can it be done?
-
April 1st, 2004, 12:20 PM
#2
Yes.
"UPDATE MyTable SET MyYesNoField=False;"
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|