Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Dec 2002
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Is there a way In access 2003 to do this-see Excel attachment

    I get a list of Expires from the main office once a week—she always sorts the list by the patient name before she emails it out. I use this formula in excel --which compares the old list and the new list of names-- and tells me if any new name was added to the list.

    =IF(ISNA(MATCH(A2,names,FALSE)),"Add to Expired","allready on list")

    I have over 381,275 list of patient names in a Access table –(Active Patients) that I need to compare to the Expired Access Table which is 70,000 names long.

    Can this be done?
    Attached Files Attached Files

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    Actually Access is quite good at doing that sort of thing - as long as you have unique identifiers. The Query Wizard can create Unmatched results between two tables and does it using what is called an Outer Join. But if your table structure is similiar to the Excel workbook you attached, it appears that there is a high probability of duplicates based just on the name. Does the main office send the 70,000 list of expired patients every week?
    Wendell

  3. #3
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Here is what your query would look like - using the tables you supplied.
    Attached Files Attached Files

  4. #4
    2 Star Lounger
    Join Date
    Dec 2002
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Does the main office send the 70,000 list of expired patients every week?


    Yes the main office sends the expired patient list every week

Posting Permissions

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