Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Dec 2002
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Delete info in rows 1 and 2 but not 3 and 4

    What would be a fast way to delete all the information under "customers" and "contains" but keep all the "location" spots. I did a append query based on criteria to move the information to the "no longer customers table" now I can get rid of there names and the contains but I need to keep the "location" field alone, because I will reuse all those spots with new customers. Right now I'm tabbing down-hitting delete-tab-delete-tab-delete in both the "customer" and the "contain" fields. Last week I have over 300 names along with there 300 contains ---that was 600 tab-deletes I did. Please help.

  2. #2
    New Lounger
    Join Date
    Dec 2015
    Posts
    24
    Thanks
    1
    Thanked 0 Times in 0 Posts
    I think your title should be delete info in columns 1 and 2 but not 3 and 4.
    Rows are for records, and columns are for field (name)s.
    Sorry, but this does not answer your question.

  3. #3
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,191
    Thanks
    48
    Thanked 986 Times in 916 Posts
    Without knowing how your table is structured we can't really advise on a query.
    What database are you using?
    What is the table structure?

    cheers, Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •