How to visualise overlapping appointments

[elpidoforos]

I have a table: tbl_Appointments in which I store information about appointments.
Fields are: ApptName, Apptlocation, ApptDate, ApptStart, ApptEnd.

I found a Weekly calendar report made by Duane Hookom which puts all the appointments at the appropriate position on the form using details_format Event in VBA.

Appt(.top) is defined by looking at difference between report start time and apptStart
Appt(.left) is determined by looking at difference between report start Day and ApptDate day


Appt(.Height) = difference between ApptStart and ApptEnd.

I need to take this a step further because I need to allow the scheduling of multiple Appointments at the same location at the same time.
Example 27 may 2014
1. Kerkcafe from 08:00 to 09:00
2. Kerkcafe from 09:00 to 14:00
3. Kerkcafe from 10:00 to 12:00
they all have the same name but imagine if they were completely different from each other

in this case the box 3 will overlap on box 2 on the report
so what i'd need in this case is cut the width of both those boxes in half and have box 3 start at normal left calculation + box 2.width property

when i have many overlapping appointments on a single day i dont have a clue where to start coding this.

here is a picture of my report with overlapping Appointments that do not split and or move

any help would be greatly appreciated

[orange]

see this example from Baldyweb