Filter results based on monthly data

[jimmy0305]

Hello everyone

I have medication & diagnosis field in my query and I would lik
to print all the medications & diagnoses of
each patient based on their monthly diagnoses & medications. eac
patient could have several diagnoses
medications per month

here's the report example

Unit PT Name Age Jan ( Dx - Mx/Dose) Feb ( Dx - Mx/Dose) Mar ( Dx
Mx/Dose
A11 Doe, John 111 - Tylnl,10mg 222-Tylnl,10mg,Asprn,10m
111-Apsrn,10mg

Many Thanks
:

 

[Guest]

I am not sure what you are asking but it looks like the results of a crosstab
query.

 

[jimmy0305]

Actually, I tried to use crosstab but I can't figure out how to lis
all the Diagnoses and Medications per month. I can only list th
medication
count per month. I'm not really proficient in access. How can I lis
all the Diagnoses & Medications per month

Here the SQL
TRANSFORM Count(Any_Class_Meds.Meds_Code) AS CountOfMeds_Cod
SELECT Any_Class_Meds.[Patient's Name], Any_Class_Meds.Meds_Code
Count(Any_Class_Meds.Meds_Code) AS [Total Of Meds_Code
FROM Any_Class_Med
GROUP BY Any_Class_Meds.[Patient's Name], Any_Class_Meds.Meds_Cod
PIVOT Format([Psych_visit],"mmm-yyyy") I
("Jan-2005","Feb-2005","Mar-2005","Apr-2005","May-2005","Jun-2005","Jul-2005","Aug-2005","Sep-2005","Oct-2005","Nov-2005","Dec-2005")