I have a DB that relates 3-tables. Table(1) "Company" has 1-record. Table(2) "Patients" has 1-record, and table(3) "HepShots" has 3-records. When I run the report, I can sort by company then Patient, and then all 3-records of the tblHepShots. I would like the report to show Company, Patient, then goto last record in the tblHepShots and add (1) to it. How do I do this on the report form?
Thanks....