I have to either frequently spend hours preparing an archaic report by hand
in excel for change resistant paper people or figure out how to display the
data I have in an ms access table like they want it.

Just employee start and end time pairs are in the table.

I need to convert that into strings and organize it to show who was on duty
for each 1/2 hour of the day. They are really stuck on their format- so I'm
hoping to learn how to do this if it is even possible. If it is not possible-
how should I accomplish it to represent the data visually as that is what it
really seems to me that they are asking for?



Table
name start end
Bob T 2/2/2010 8:00 am 2/2/2010 4:00 pm
Tom M 2/2/2010 10:00 am 2/2/2010 6:00 pm

Report

2/2/2010

8am BT
830 BT
9am BT
930 BT
10am BT,TM
1030 BT,TM
11am BT,TM
1130 BT,TM
12p BT,TM
1230 BT,TM
1pm BT,TM
130 BT,TM
2pm BT,TM
230 BT,TM
3pm BT,TM
330 BT,TM
4pm TM
430 TM
5pm TM
530 TM
6pm

Of course there are more than 2- 24 to be exact, with up to 7 on duty during
any 1/2 hour period around the clock. And the data would be for a 1 month
period...

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/201003/1