Results 1 to 1 of 1
  1. 04-07-2011, 10:50 PM #1
    suryaprasad
    suryaprasad is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2011
    Posts
    3

    Lightbulb Remove Duplicates Based on Criteria

    Hi Experts,



    Need a small help in the below database attached , i need a query to delete the records as explained below :

    in the database we have ID, Country Code, Country Tag, Service_Req, in these fields except the ID the other fields are having duplicate's

    What i want is ?

    If the ID is different and the country code is same and Country Tag is also same but has a different Service Number then it should not be deleted as shown below
    Last edited by suryaprasad; 04-10-2011 at 01:30 AM.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. IIF Criteria based on another table
    By BED in forum Queries
    Replies: 6
    Last Post: 11-24-2010, 01:55 PM
  2. Remove Combo-Box Duplicates - Ignore Autonumber
    By Cheg in forum Forms
    Replies: 2
    Last Post: 08-17-2010, 02:58 PM
  3. How to remove duplicates
    By TonyBender in forum Access
    Replies: 0
    Last Post: 10-21-2009, 10:27 PM
  4. Counting records based on specified criteria
    By GrnISSO in forum Queries
    Replies: 2
    Last Post: 10-04-2007, 03:07 PM
  5. Labels printout duplicates based on records in subform
    By SUSANVV in forum Reports
    Replies: 1
    Last Post: 05-27-2006, 12:35 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums