Deleting all the text in a column

[joannakf]

I want to write a query that deletes all the text in a column but not the entire column.



help please?

thanks!

[alansidman]

What you want is an update query. This will allow you to specify a particular field in a table to update (in your case--updating the value in each record to Null. Her is a basic into to update queries. In your case, you would specify the field and update it to Null.

Alan

[tanvi]

I want to write a query that deletes all the text in a column but not the entire column.

help please?

thanks!

You can use two queries to delete the records from table:

1) Use a delete query to remove entire records (rows) from a table or from two related tables, in one operation. Delete queries remove all the datain each field, including the key value that makes a record unique.

2)Use an update query to delete individual field values from a table, Anupdate query let you delete values by updating the existing values toeither a null value (that is, no data) or a zero-length string (a pair of double quotation marks with no space between them). (As Alan already suggested)

There are some points which you should verify before using a query to delete data; you can find it from here:http://office.microsoft.com/en-us/access-help/delete-data-from-an-access-database-by-using-a-query-HA010342091.aspx