Results 1 to 1 of 1
2001-12-11, 16:03 #1
- Join Date
- Dec 2001
- Thanked 0 Times in 0 Posts
Report Hours by Category and Duration (2002)
I want to create a daily report of my time by categories. I log my work with appointments that I assign categories to. (The categories are the number assigned to the project for billing.) I want to automate creating a report that will sum the hours I logged for each category used that day. Ideally, it would create a table for each category that lists the each appointment's subject, start time, end time, duration, and notes, with total of time spent for that category and a sum of the time worked that day. Outlook has the data! but how do I extract it for the report? Can this be done with views?? Would I need to use VBA?
I think this would be easy if I were using Access to log all my time and I suppose that may be my solution. However, I don't want to run Outlook, Access, and the several other programs I use all day at the same time. Can Access pull data out of an Outlook database? <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15>