I am creating a report and the top half is Patient Demographic and I want the bottom half to show every entry that has been made regarding their testing.
Any ideas how I should go about this- some thing fairly simple please
You should have provided some basic information about your data (tables and relationships).
Generically, create a query with all the information and use it as the record source for the report. Set the sorting and grouping to "Patient Demographic" and display the group header for displaying the "Demographic" fields. Put the testing information in the detail section.
It is quite basic
a table for Patient Demograhics
and a table for Testing Information
The testing info are given autonumber
the relationship is the patient ID Number.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.