Filter results based on monthly data

[jimmy0305]

Hello everyone,

I have medication & diagnosis field in my query and I would like to print all the medications & diagnoses of
each patient based on their monthly diagnoses & medications. each 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,10mg 111-Apsrn,10mg


Many Thanks,

 

[WayneRyan]

Jimmy,

What's your question?

You have to give us your table structures (and/or query), or include a
sample database.

Need more info,
Wayne

 

[jimmy0305]

I'm sorry I didn't make it clear... Here's the actual example.

In my query I have four tables:
tblPatientInfo
tblDiagMed
tblDiagdetail
tblMeddetail

tblPatientInfo
PatientID
Last
First
Unit
DOB

tblDiagMed
PatientID
PsychVisitDate
MxID
DxID

tblDiagdetail
DxID
DiagCode

tblMeddetail
MxID
MedCode
Dosage

In my Query, I have these fields:
Unit Patient Name Age DiagCode MedCode Dosage

On the report:
I want to list like this:
-------------------------Jan-05--------Feb-05
Unit Patient Name Age Diag Med Dos Diag Med Dos

A11 Doe, John 45 111 tylnl 10mg----222 Asprn 10mg
-----------------111 Asprn 15mg
-----------------222 clusvl 10mg

I tried to use crosstab but I can't figure out how to list all meds & diagnoses.
It only gave me counts of meds. I'm only a novice access user.

Many thanks again Wayne...