You don't specify hours or if it's just appointments, so assuming the latter, tables something like (omit the parts in parentheses for field names)
tblPatients |
|
tblApptType |
|
tblAppts |
PatientID (PK, auto number) |
|
ApptID (PK, auto number) |
|
ApptID (PK, auto number) |
Fname |
|
ApptType |
|
PatientID (fk from tblPatients) |
Lname |
|
Description |
|
ApptID (fk from tblApptType) |
Address |
|
etc. |
|
ApptDate |
DOB |
|
|
|
Location |
etc. |
|
|
|
etc |
Your form listbox contains the appointment types and you either select all or just those that apply. There are lots of examples of how to include an ALL feature in listboxes.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.