delete column values (but not the column)

#1

Hi,

A collegue of mine has made an access entry field and keyed in all the
data. Now I have to key in the same data in the same database.
However, I first need to delete the values in several colums in order
to start. i.e. i need the current values of a certain column to
replace with the default value. I have one column with 1,2,3 values,
but in need to delete or replace these values. Any ideas? Many thanks.

Raoul

#2

"Uli" <raoulreulen (AT) hotmail (DOT) com> wrote

Quote:

Hi,

A collegue of mine has made an access entry field and keyed in all the
data. Now I have to key in the same data in the same database.
However, I first need to delete the values in several colums in order
to start. i.e. i need the current values of a certain column to
replace with the default value. I have one column with 1,2,3 values,
but in need to delete or replace these values. Any ideas? Many thanks.

Update query.

UPDATE TableName SET FieldName = Null, OtherFieldName = 0, etc..

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

delete column values (but not the column)

comp.databases.ms-access comp.databases.ms-access

delete column values (but not the column) - 12-19-2004 , 08:55 AM

Re: delete column values (but not the column) - 12-19-2004 , 09:36 AM