Delete Records

[gfcjr]

Hi,
I want to delete all records in One Field, but later add records in the same field, without going to the table and deleting the field it's self, the Field is a Date field that will be use again in 3 months, please help, I don't want to delete them manualy there are over 600 records

[This message has been edited by gfcjr (edited 03-16-2000).]

 

[Neal]

Create a query with just that field. Convert that query into an append query. (Click on Query on the menu bar and select Update Query)
For Update To:, enter Null. For From:, enter Is Not Null. Run the query.

 

[gfcjr]

Thanks Neal, that worked