debbiecarvery
MIS
Hello,
I have built a production database in Access 2000 and it runs a few reports. I have one report where most of the calculations were done in the report and run off of a query.
I need to add some fields to the report but I cannot get the fields to calculate properly.
I am trying to add the total numbers of hours an employee worked.For example John has worked 20 hours, in my query this "20 hours" shows up 25 times ( the number of items on John's page).When I try to sum it it gives me a total of 500 hours. How can I add this field to my report to give me the actual number of hours this employee worked ?
I could make a brand new query but then I would need to start my report from scratch and that is what I do not want to do, since many of the calculations are done directly in the report.
Thanks
Debbie
I have built a production database in Access 2000 and it runs a few reports. I have one report where most of the calculations were done in the report and run off of a query.
I need to add some fields to the report but I cannot get the fields to calculate properly.
I am trying to add the total numbers of hours an employee worked.For example John has worked 20 hours, in my query this "20 hours" shows up 25 times ( the number of items on John's page).When I try to sum it it gives me a total of 500 hours. How can I add this field to my report to give me the actual number of hours this employee worked ?
I could make a brand new query but then I would need to start my report from scratch and that is what I do not want to do, since many of the calculations are done directly in the report.
Thanks
Debbie