Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Louisville, Kentucky, USA
    Posts
    605
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re-Occurring Visits (ADK)

    I have a table that holds Inpatient Data.

    I need to determine if a patient has made re-occurring visits to the hospital in a 30 day period.

    I have Patient ID, ServiceFromDate (SFD), ServiceToDate (STD), and DX.

    A TRIP is considered if the patient returns to the hospital within 30 days of his/her last discharge date (STD).

    Scenario:

    Record 1 -Visit 1:
    SFD STD
    1/1/06 1/5/06

    Record 2 - Visit 2:
    SFD STD
    2/10/06 2/15/06

    I need to compare the STD of Record 1 to SFD of Record 2. If the total number of days between the two is 30 or less then return that record.

    In the above scenario, this record WOULDN
    Roberta Price <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Re-Occurring Visits (ADK)

    You need to create a query to which you add the table twice. You can then use criteria on the date fields to select the records you want. See screenshot below.

Posting Permissions

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