lulu50
asked on
Print list of allergies on a report.
Hi,
I have a report called (RPPatientVisit) in this report I have to list the patient allergies.
Every patient should have a different list of allergies. the allergy list are in table (tblAllergies) and (tblPatAllergies) is for the relationship to each patient.
the list are found in this form (frmPatients) Patient Allegies and Name is (lbxPatAllergies).
That list should be listed on the report. (RPPatientVisit) Seperated each word by comma from the list.
if the list is more than 5 word the report should expand automatically.
so, that way if the list grow it can all be seen on the report.
I might need to create some king of loop to loop through the list and print them on the report.
I am not sure any ideas.
Thanks,
testVisit.mdb
I have a report called (RPPatientVisit) in this report I have to list the patient allergies.
Every patient should have a different list of allergies. the allergy list are in table (tblAllergies) and (tblPatAllergies) is for the relationship to each patient.
the list are found in this form (frmPatients) Patient Allegies and Name is (lbxPatAllergies).
That list should be listed on the report. (RPPatientVisit) Seperated each word by comma from the list.
if the list is more than 5 word the report should expand automatically.
so, that way if the list grow it can all be seen on the report.
I might need to create some king of loop to loop through the list and print them on the report.
I am not sure any ideas.
Thanks,
testVisit.mdb
ASKER
I made some changes to the query report (QrReport). I linked the tables but it is displaying the same information twice.
To view the report from this form (frmPatients) double click on the list date of report called (subfrmDateofVisitReport).
I want all list of allergies to be listed on one line seperated by comma.
Thanks,
testVisit.mdb
To view the report from this form (frmPatients) double click on the list date of report called (subfrmDateofVisitReport).
I want all list of allergies to be listed on one line seperated by comma.
Thanks,
testVisit.mdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you Excellent.
tblAllergies which list the alergies
tblPatAllergies which links patients to the alergies, and
tblPatient the name of patiens.
Make a query and include these three tables (link them if they do not get linked automatically) add the necessary fields you want:
1. view
2. apply criteria to
save the query as qryReportAlergy
Now, start a report using this query and completet the design of your report. After having done all this, from your form the necessary criteria will be selected and upon clicking on cmdReport the report will show up displaying the data per your criteria set on your form.
But first complete the report and then we will take care of the criteria portion.
Mike