Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

History of patient on a Report

Status
Not open for further replies.

Carrie241

Technical User
Nov 7, 2008
2
CA
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.

Duane
Hook'D on Access
MS Access MVP
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top