98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access courses in london - Report totals
microsoft access courses in london - Report totals
Resolved · Low Priority · Version Standard
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
Mon 4 Dec 2006, 10:09Trainer Richard said...
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.
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.
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. |
Access tip:Create calculated fields that work out your ageYou can uset eh year function to work out the year from NOW function and then subtract it with your date of birth type field |
