bull city bob
New Member
- Joined
- Feb 6, 2006
- Messages
- 14
Hi,
I have 20 or so tables - Patient Number is common to all the tables.
Some of the tables have only one row per patient.
Many of the tables have multiple rows per patent. For example:
The diagnosis table may have several entries for Staph-Infection for the same patient, thus several rows for that patient. And the diagnosis table has many other columns - so that patient could also have rows for that (a date field differentates the different staph-Infections but the other tables don't necessarily have all the same dates).
The hospitalization table for that patient might have several rows for the same patient as well.
I am trying to determine the best way to consolidate the data for each patient without getting duplicate rows. I would even consider excel if I could just group by a patient. Ideally, I would like to design a report in Access that consolidates all of the table data by Patient Number.
I have 20 or so tables - Patient Number is common to all the tables.
Some of the tables have only one row per patient.
Many of the tables have multiple rows per patent. For example:
The diagnosis table may have several entries for Staph-Infection for the same patient, thus several rows for that patient. And the diagnosis table has many other columns - so that patient could also have rows for that (a date field differentates the different staph-Infections but the other tables don't necessarily have all the same dates).
The hospitalization table for that patient might have several rows for the same patient as well.
I am trying to determine the best way to consolidate the data for each patient without getting duplicate rows. I would even consider excel if I could just group by a patient. Ideally, I would like to design a report in Access that consolidates all of the table data by Patient Number.