I work for a hospital company and am in the process of designing database that will track our patient volumes (number of admissions, how long the patient stayed, along with other metrics). We have 10 hospitals and each of those hospitals has multiples lines of business, both inpatient and outpatient. I won't be tracking patient names or anything like that, just volumes (numbers). What would be the best way to set this up?

---

Reply from Alex Hedley:

You could create a Hospital Table to store each Hospital
You could then have a Table that stores the Patients.
You could have a combo with a choice of Inpatient/Outpatient
Then queries to count them up.