»
 

Go Back   ResellerRatings Store Ratings > ResellerRatings Forums > Tech Support

Reply
 
LinkBack Thread Tools Display Modes
Old 11-07-2003, 12:18 PM   #1 (permalink)
Registered User
 
Join Date: Nov 2001
Posts: 170
Turnip12 is on a distinguished road
Access, clearing field in every record

I'm trying to clear a field in all of my records, what's the best way to go about doing this? As of now, I just have a form that clears the field, but it only does it for the current record, so I have to go through every record on that form to do so.

Turnip12 is offline   Reply With Quote
Old 11-09-2003, 07:44 PM   #2 (permalink)
Registered User
 
Join Date: Sep 2002
Posts: 265
Creosote is on a distinguished road
Make a new query.

Code:
UPDATE Table1 SET Field1 = NULL
Creosote is offline   Reply With Quote
Reply




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Most Active Discussions

Recent Discussions

All times are GMT -6. The time now is 11:18 PM.