Results 1 to 2 of 2
  1. #1
    Dgalaxy is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    May 2020
    Posts
    5

    Help with Creating a table without duplicate records

    Experts:

    I a beginner in access. I need some help creating a Query to filter the right City.

    Background:

    Attached is a sample database table and the query results i am getting.

    I am trying to query the number of encounters for each site based on the effective date(service date). I have a startdate and enddate enrollment date. I am trying to create a query where i say if my effective date is in between start date and end date pick the matching clinic. But sometime my effective date is before my start date for eg: For MID "***********7500” my effective date is 4/29/19 in this case i want it to pick "*****_HEMET". Can you Please assist me how to handle this.
    Attached Files Attached Files
    Last edited by Dgalaxy; 05-30-2020 at 10:46 AM. Reason: Spelling

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,820
    Well, if effective date is not between start and end dates the record will not be captured. How would you think this could be handled otherwise? Query can only follow the rules you give it. So what rule do you want to apply if there is no match of effective date between start and end dates?

    Did not provide sample db, only a Word document with image of part of table.
    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: 2
    Last Post: 12-22-2014, 11:28 AM
  2. how to solve the error when creating duplicate records?
    By Rafegh in forum Database Design
    Replies: 10
    Last Post: 08-15-2014, 01:50 PM
  3. check duplicate records within same table
    By cthorn112 in forum Queries
    Replies: 0
    Last Post: 06-19-2012, 12:23 PM
  4. Replies: 2
    Last Post: 04-13-2012, 12:53 AM
  5. Replies: 6
    Last Post: 03-15-2012, 06:21 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