Delete Contents of a Field

[Guest]

Hello,

I have a table with over 1000 records. Every three months we have to clear
the contents of a date field. Is there an easy way to clear that field
without having to go into each record and delete the contents?

Thank you.

 

[Allen Browne]

Use an Update query to set the date to null.

1. Create a query that uses this table.

2. Change it to an Update query (Update on Query menu.)
Access adds an Update row to the grid.

3. Drag the date field into the Query grid.

4. In the Update row under this field, enter:
Null

5. Run the query.

 

[Guest]

THanks a lot!

Use an Update query to set the date to null.

1. Create a query that uses this table.

2. Change it to an Update query (Update on Query menu.)
Access adds an Update row to the grid.

3. Drag the date field into the Query grid.

4. In the Update row under this field, enter:
Null

5. Run the query.

 

[Marcin]

THanks a lot!

===========================================================================
FULL LEGAL SOFTWARE !!!
Games, video, program, image, chat, questbook, catalog site, arts, news,
and...
This site it is full register and legal software !!!
Please download and you must register software !!!

PLEASE REGISTER SOFTWARE:
http://www.webteam.gsi.pl/rejestracja.htm
DOWNLOAD LEGAL SOFTWARE:
http://www.webteam.gsi.pl

Full question and post: http://www.webteam.gsi.pl

Contact and service and advanced technology:
http://www.webteam.gsi.pl/kontakt.htm
FAQ: http://www.webteam.gsi.pl/naj_czesciej_zadawane_pytania.htm

Please add me URL for you all site and search engines and best friends !!!

Me site:
SERWIS WEBNETI: http://www.webneti.gsi.pl
PORTAL WEBTEAM:http://www.webteam.gsi.pl
LANGUAGE: http://www.webneti.cjb.net

==========================================================================