If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Lame Report Requirements
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 |
Thread Tools | |
Display Modes | |
|
|