Calendar - Scheduling multi-view

[WmB]

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..........

 

[PC Datasheet]

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
[email protected]
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.

 

[John Marshall, MVP]

And the cost is? Or did you copy this from someone else?

John... Visio MVP

 

[Duane Hookom]

There are several calendar reports at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4. You might find what you
need there.

 

[WmB]

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.

 

[Duane Hookom]

Don't give up so quickly. You can concatenate several patients into a single
expression using the generic concatenate function found at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

Once you have a query that concatenates the patients, you can use it in
week-at-a-glance type calendar.

 

[Boxer]

If someone have something like this I really need it, please send me a link.

 

[Duane Hookom]

It would help you you asked a specific question. Someone could probably
provide free advice.

 

[PC Datasheet]

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
[email protected]
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!

 

[John Marshall, MVP]

These newsgroups are for free peer to peer support, not for soliciting.

John... Visio MVP

 

[Boxer]

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!

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