OK. I tried, but I failed. This is the basic query I have. Now, I have to add the information about being able to select the top 5 of each client's drug date (Drug_History.Drug_Date). This is way over my head, so if you can help, I'd really appreciate it.
Thanks.
SELECT Client_Case_Information.Client_Last_Name, Client_Case_Information.Client_First_Name, Client_Case_Information.CaseID, Drug_History.Drug_Date, Drug_History.CRet_Amount, Client_Case_Information.Status, Case_Color_Codes.Start_Date
FROM (Client_Case_Information INNER JOIN Drug_History ON Client_Case_Information.CaseID = Drug_History.CaseID) INNER JOIN Case_Color_Codes ON Client_Case_Information.CaseID = Case_Color_Codes.CaseID
WHERE (((Client_Case_Information.Status)="PA and MP Signed") AND ((Case_Color_Codes.Start_Date) Is Not Null))
ORDER BY Client_Case_Information.Client_Last_Name, Drug_History.Drug_Date;
__._,_.___
Posted by: Sheryl.Jones@state.mn.us
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar