I am trying to develop a database for a local clinic that is operating as a not-for-profit. I have a table that has the following fields
AdmID - Autonumber
PatientID - Number
AdmType - Dropdown (based on another table) (Values are ER Visit, Admission, Readmission,... etc)
Date - Date/Time
Note - Memo
The goal is to take the values from the AdmType field, group them, and then perform calculations based on those values. These are to be sorted by two user defined dates.
I had originally had two fields "ParmValue:[Start_Date]" & "ParmValue2:[End_Date]" which would define the two dates needed.
I'm open to Ideas I'm totally at a loss.
Tables:
Patients
Admissions