delete query help needed

  • Thread starter Thread starter papa
  • Start date Start date
P

papa

Hi,
Currently I have 5 Tables which I run a delete query on
once a week to clear out rows which are obsolete. These
work fine

What I need help with is one table in which I just want to
delete the content of a single column but still have the
column there to be refilled again.

eg:
Table: Del_Employees
This table has 7 columns
What I want to do each week is delete the contents of
column 4 which is called "TimeChecker" The delete ouery
once run will delete all cells with any content and leave
the column blank to filled again for the following week.

Is this possible?

Any help would be much appreciated!
 
You need to create an Update query not a Delete query.
In the Update To: put "" or 0 depending on if it's text
or a number. In the Criteria put <> "" or > 0 depending
on if it's text or a number.

HTH Marty
 
Back
Top