highlighting specific lines

  • Thread starter Thread starter KAREN POST via AccessMonster.com
  • Start date Start date
K

KAREN POST via AccessMonster.com

I have created a report based on patient hospital admissions.

One patient can have many admissions.
One patient can have many diagnoses.
One admission may have many diagnoses.
One diagnoses may have many admissions.

What I would like to do is for each admission

display the all diagnoses for the patient and then highlight the diagnoses associated with the admission.

Eg
Patient 1
Admission 1

Patient 1
 
Sorry, I accidently posted the unfinished msg.
Here are the rest of the details.

I have created a report based on patient hospital admissions.

One patient can have many admissions.
One patient can have many diagnoses.
One admission may have many diagnoses.
One diagnoses may have many admissions.

What I would like to do is for each admission, display the all diagnoses for the patient and then highlight the diagnoses associated with the admission.
In the example below, the brackets represent the diagnoses associated with the admission.

Eg
Patient 1
Admission 1
(Diagnoses 1)
Diagnoses 2
(Diagnoses 3)

Patient 1
Admission 2
(Diagnoses 1)
(Diagnoses 2)
Diagnoses 3

I would really appreciate some assistance.
Thanks
 
I suggest you try a different approach. There's no need to include in your
report any diagnosis that a patient hasn't received.
You need the tables:
TblPatient
PatientID
FName
LName
Etc

TblDiagnosis
DiagnosisID
Diagnosis

TblAdmission
AdmissionID
PatientID
AdmissionDate
Etc

TblAdmissionDiagnosis
AdmissionDiagnosisID
AdmissionID
DiagnosisID

For your report, you need a Report/Subreport. For the main report use a
query that includes TblPatient and TblAdmission. Fields:
AdmissionID
Patient:[LName] & ", " & [FName] Calculated Field
AdmissionDate

For the subreport use a query that includes TblAdmissionDiagnosis and
TblDiagnosis. Fields:
AdmissionID
Diagnosis

Open the main report in design view, select the subreport control, open
properties and go to the Data tab. The linkmaster and linkchild properties
should have AdmissionID. If not, click on the three dots at right and follow
directions to get AdmissionID.
 
Back
Top