Calendar - Scheduling multi-view

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to show a detailed schedule without buying a separate program?

Here is my table:
[patientId]
[date]
[time]
[therapistId]


My issue is that there can be 8 therapists at any one time and each of them
could have 6 patients in at the same time. I need to be able to quickly see
who is busy and who is not at different times.

So it should look like this (kindof):

Date: July 6, 2009

John Anne Fred
Susan
-------------------------------------------------------------------
9:00am George A | | Sam B. | Joe M.
Greg O. | | Julie T.
| Chi M.
Adam R. | |
| Sid L.
10:00am Freda G. | Jack T. | Kim B. |
Sarah R. | Nathan D | Joshua D. |
Zach E. | Megan A | |
11:00am etc..........
 
I have an appointment scheduling Access module that does exactly what you
are asking for. If you are interested, send me an email and I will send you
a screenshot of the module.


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee.
Over 1000 Access users have come to me for help.
Need a month calendar or 7 day calendar? Contact me.
 
And the cost is? Or did you copy this from someone else?

John... Visio MVP
 
Every calendar and schedule I see does part of what I need but not all of it.

I need to be able to see multiple people scheduled at the same time and also
to be able to see the gaps in the schedule. If you have ever seen a calendar
scheduling book in a doctor or therapists office, you'll know what this need
to look like.
 
It would help you you asked a specific question. Someone could probably
provide free advice.
 
See my first response to you. I have what you are looking for!

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee. Over 1000 Access users have come to me for help.
Need a month calendar or 7 day calendar? Need appointment scheduling? Need
room reservations scheduling? Need employee work scheduling? Contact me!
 
These newsgroups are for free peer to peer support, not for soliciting.

John... Visio MVP
 
PC Datasheet said:
See my first response to you. I have what you are looking for!
Click to expand...

So what a pity Steve: WmB is not immediately contacting you?
I am sure we can help him for free!

We have something that you are missing, like ...
-- decency
-- ethics

Need examples ? contact me!

Arno R
 
If someone have something like this, please can you send it to me by e-mail,
I really need It.
Help me please:)

See my first response to you. I have what you are looking for!
Click to expand...

So what a pity Steve: WmB is not immediately contacting you?
I am sure we can help him for free!

We have something that you are missing, like ...
-- decency
-- ethics

Need examples ? contact me!

Arno R
 
Back
Top