Microsoft Access Forums

Go Back   Microsoft Access Forums > Access Forums > Access

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 06-23-2008, 08:43 AM
Novice
 
Join Date: Jun 2008
Location: Spanaway, Washington
Posts: 3
Charles Waters is on a distinguished road
Send a message via ICQ to Charles Waters Send a message via AIM to Charles Waters Send a message via MSN to Charles Waters Send a message via Skype™ to Charles Waters
Default Deleting Record Contents, not complete record...

I know this is something that probably can't be done, but thought I'd ask anyways...

I'll use an example of what I am looking for...

Records: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10
Content: Name, Rank, Serial Number

I am trying to find a way that I can do something like a Delete Query to erase *only* the Content under Record 4, but I want to keep 4 in there as a record that can be filled out again...

Is there an easy way to do this!?
Reply With Quote
  #2  
Old 06-23-2008, 11:36 AM
jya jya is offline Windows XP Access 2007 (version 12.0)
Competent Performer
 
Join Date: Sep 2007
Location: Chicagoland
Posts: 109
jya is an unknown quantity at this point
Default

To delete only specific fields, you can run an update query and set your fields to 'Null' to erase the content.
Reply With Quote
  #3  
Old 06-24-2008, 10:00 AM
Novice
 
Join Date: Jun 2008
Location: Spanaway, Washington
Posts: 3
Charles Waters is on a distinguished road
Send a message via ICQ to Charles Waters Send a message via AIM to Charles Waters Send a message via MSN to Charles Waters Send a message via Skype™ to Charles Waters
Smile

Works like a champ, thank you! Even have it changing some values in other fields...

Thanks!
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Delete a record f.crocco Programming 1 10-08-2007 05:28 AM
referencing each record grgerhard Forms 1 11-11-2006 05:15 PM
i need record dividers dunston Reports 1 11-11-2006 04:57 PM
How to Find a Record lschlitt Programming 2 09-09-2006 04:24 PM
Copy a record RHall Programming 2 02-23-2006 04:40 AM


All times are GMT -8. The time now is 02:46 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.3.2 ©2009, Crawlability, Inc.