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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete Query: Could not delete from specified tables 0
How do I delete the data in a field 3
Access 97 delet query problem 1
Split data in field on character return 0
SUM in a UNION query 2
Delete query is not working 4
"Specify the table containg the records you want to delete" messag 3
Excel How do I delete images in a specific range 1

Back
Top