Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2015
    Posts
    4

    Unanswered: Creating a decision support tool - need to match contents

    I'm creating a clinical decision support tool for our clinic with access. Without getting into too much detail, our clinic is required to review all medications that we prescribe to patients to make sure the patient has the correct certification to receive that med. Each certification allows for a specific set of drug classes.

    In the DB, I have the prescriptions data imported (which includes the drug class code for each patient's Rx), a list of the patient's current certifications, and a crosswalk that outlines what certifications are allowed under each drug class code. So far, I've been able to pull in patients' certs and drug class codes they're currently using into a single query. The final step is to decide whether the patient's drug class code is allowed for under their current certs. This is the part I can't figure out.

    Example: Query 1 contains Patient A who is on drug class code 1 and has certification A. Table 1 shows that for drug class code 1 patient must have certs B, C, or D. How do I create a query that gives me an output that says "No Match" for patient 1?

    UPDATE: I'm trying to do something like Iif("*[Certs_Combined]*" Like "[Cert1]", "Yes", "No"). [Certs_Combined] is a list of all the patient's current certs in one combined string. [Cert1] is one of the allowable certs for that drug class code. This formula isn't working though. Anyone see an obvious reason why?
    Last edited by cmray58; 08-08-16 at 17:02.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Can we see the table design?
    When asking for help you need to take a step back from the detail you know, but others wont ferinstance 'patient's Rx'
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    May 2016
    Posts
    89
    Provided Answers: 4
    Hi cmray58

    I'll proceed as follows, create a module public VBA function and call it from your Sql request.

Posting Permissions

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