Results 1 to 1 of 1
  1. #1
    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.

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

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. 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. 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
  •  
Other Forums: Microsoft Office Forums - Senior Forums