View Full Version : Clear Range of Data


joellita
07-12-2005, 11:42 AM
Is it possible to clear the cotents from various records but only the values in one column. Like let's say I just want the delete the values in the Price column for a range of about 6000 records. Not the whole records just those price values.

I can't seem to find a way to do this without sitting there and pushing down and backspace over and over again.

thanks,
joëlle

DanG
07-12-2005, 03:50 PM
You can use an update query. """ CAUTION """ test on a copy first.
Make a new select query and include the criteria field and the field to be changed. Set your criteria, like a date or whatever, then go to "query" in the menu bar and select "update query". Your query design grid will have a new row called "update to" type the new value you want in the "updat to" row, this will be the value that replaces what you currently have in there.
Be warned....Update & Delete queries are permenent so as stated above make a copy to practice on.