How do I delete data in a field in Access but not delete the whol.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a data base for my shopping list. I have a field which lists all the
items. When I want to print the list for that week I put "Y" in the purchase
field. I want to be able to delete the "Y" so I can start a fresh each week.
I have tried the delete query but this deletes the whole record.
 
Leanne said:
I have a data base for my shopping list. I have a field which lists all the
items. When I want to print the list for that week I put "Y" in the purchase
field. I want to be able to delete the "Y" so I can start a fresh each week.
I have tried the delete query but this deletes the whole record.
Click to expand...


Use an UPDATE query.

UPDATE table Set purchase = Null
 
Back
Top