Results 1 to 3 of 3
  1. #1
    kris335 is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2011
    Posts
    23

    deleting some data

    Sorry, I wasn't sure which topic to post this under....



    I'm using a copy of last year's database for my county's Christmas program. All my business listings have stayed the same but I need to delete data out of certain fields within each record without deleting those fields (sort of like the "clear contents" option in Excel).

    I have 9 fields (in 336 records) that I basically want to wipe all the data out of to start fresh for the new holiday season. (Not all 9 fields are populated in each record, in some records, none of them have data.)

    Thanks for any help. Please let me know if you need more info.

    Kristy
    @ Meck DSS

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,849
    Without knowledge of your application, is it possible to add a Date field eg DateOfXmasProgram
    so that you could use the same tables and just update the this new date field. For all existing records, since you only had one set of records, update the date field with last years Date. That way you wouldn't have to delete any records.

    Just a suggestion -- without knowing any of the details.

  3. #3
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    You want to remove data from all records? Run an UPDATE query. Under each of the 9 fields on the UpdateTo row use: Null

    Alternative is to delete and recreate the fields.

    Or if you want to retain previous year info, modify db as orange suggests.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 8
    Last Post: 02-03-2011, 09:51 AM
  2. Replies: 11
    Last Post: 12-14-2010, 01:25 PM
  3. Deleting filtered data
    By mylesg in forum Queries
    Replies: 1
    Last Post: 10-23-2010, 07:18 PM
  4. Replies: 1
    Last Post: 07-19-2010, 09:50 AM
  5. Deleting certain data
    By swindmiller in forum Queries
    Replies: 3
    Last Post: 02-17-2010, 10:39 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums