Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access courses in london - Report totals
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
microsoft access courses in london - Report totals
Resolved · Low Priority · Version Standard
Reply Fri 1 Dec 2006, 09:23Delegate Jane said...
Jane has attended:
No courses
Report totals
I have set up a report that is grouped by employee, each employee works on a number of projects and are allocated days per month for each. so in the detail of my report I have project names (not showing duplicates); then the months and then the allocated days per month per project. I have inserted a total days text box in the footer and this totals all the days per employee.
My question is how can I get it to group the same months together and give a total of days allocated per month? Thanks
For upcoming training course dates see: Pricing & availability
RE: Report totals
Although I do not use MS Project, my first thought was that it may be a better suited application to use for you purposes. This was a gut response, and may not be correct, depending on your environment. If anyone else on the forum, has any thoughts on this, please post your reply.
<b>Access</b>
A question I have is: Do you want to display the "total of days allocated per month" on the same report, or can it be on a different one?
If same, I am not clear when you say <b>"same months together"</b>.... please clarify
If different report, you could create a query that gives the data you are looking for.
The way I try to create processes in Access databases is to understand the smaller modules of the process I am trying to create. It is easier to manipulate data in queries than it is in reports, generally.
Reply Wed 6 Dec 2006, 09:34Delegate Jane said...
RE: Report totals
I want it on the same report, I have since figured out how to group by month so for instance Employee 1 January - Project A (19 days); Project B (2 days). Employee 1 February - Project A (19 days); Project C (2days) and so on. So what I want to do is have a total after January saying total days - 21.
I am setting up a resource management db to enable project leads to schedule and plan resource for current and future projects. The reason for access is one can create user friendly forms for inputting and management can click a button at any point to draw on an up to date report.
Reply Wed 6 Dec 2006, 09:46Delegate Jane said...
RE: Report totals
Not to worry I have figured it out. You go View - Sorting & Grouping - group header (yes) group footer (yes) and then insert in the month footer section.
|