Create a query of the people/patients, with status either "open" or "not closed" (or Date_closed IS NULL, whatever your field is). You will probably re-use this, and it will limit you to the open case population. Join this query to the table/query with the drug_date data on patient_id or whatever field they use as parent/child.
hth,
Steve
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Wed, 6 Aug 2014 06:46:23 -0700
Subject: [MS_AccessPros] Query Help- Drug Screening
hth,
Steve
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Wed, 6 Aug 2014 06:46:23 -0700
Subject: [MS_AccessPros] Query Help- Drug Screening
Good Morning.
I am trying to figure out how many drug screens [drug_date] were requested between 1/1/13 and 12/31/13. That in itself is easy enough for me to do:) However, some of the cases are now closed [date_closed].
Unfortunately (for me), the system auto generates screening dates in advance so I do not want to count all of the screens for the persons whose cases have already been closed & I cant figure out a way to set up the query to gather the data I need leaving out the screens of just the dates of the closed people post their closed date. Make sense?
I've tried several ways and get several answers- maybe just over-thinking, but don't want my data to be wrong, so here I am asking for some help setting up the parameters.
__._,_.___
Posted by: Steve Conklin <stephenmconklin@hotmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Yahoo Groups
New feature! Create Photo Albums in Groups Effortlessly
Now, whenever you share photos with your group, a new album is automatically created in the Group. It's so simple! Try it now!
.
__,_._,___
Tidak ada komentar:
Posting Komentar