|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 5th, 2005, 10:01 PM
|
|||
|
|||
How do I delete data in a field in Access but not delete the whol.
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. 
|
|
#2
March 5th, 2005, 10:27 PM
|
|||
|
|||
|
Leanne wrote:
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. Use an UPDATE query. UPDATE table Set purchase = Null -- Marsh MVP [MS Access]
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to stop opening of multiple instance of Access 2000 after upd. | Taika Bilbo | Database Design | 9 | January 12th, 2005 08:34 PM |
| Format on data to import to Access tables? (I need your advice) | Niklas Östergren | General Discussion | 5 | December 13th, 2004 02:54 PM |
| is Access 2003 any better than XP? | Gorb | Using Forms | 2 | November 11th, 2004 09:20 AM |
| Images in a database | Franz | General Discussion | 10 | October 7th, 2004 09:35 AM |
| Upload Image | Jason MacKenzie | General Discussion | 1 | September 1st, 2004 04:38 AM |
Linear Mode
