Report With Totals

[drisconsult]

Hello All

I am writing a program for a client who runs a security business. I have reports for each guard for each month, which normally list 28 to 32 activities for every day of a month.

I now need to produce a report for all guards (48) that sums up their number of hours worked and their total amount earned and list all 48 guards with their summed hours and summed totals

Can anybody help

 

[ScottGem]

Not without knowing more of your table structure. Generally you would create a query that shows sll the records for the month with the info you want on the report. Then create a report grouping on the Guard and add the relevant data. Set to summary only so the individual data is supressed.

 

[RV]

I have reports for each guard for each month

I hope you haven't set up a single report per guard, do you?

RV

 

[drisconsult]

Hello RV

The client wants and individual report on each guard so that the guard can see how many overtime hours he has worked. This program will be used in Kenya.

Hello Scotgem
Yes I am going through that route and will let you know how I get on. Many thanks to you both for taking the trouble to reply

Regards
Terence
London

 

[RV]

>The client wants and individual report on each guard<

So you need to set up one and one report only.

What you should do (that's assuming you haven't done so yet) is to introduce an unbound "search" form.
As for the monthly overview, simply put a list box on your form.
Base the list box on the table holding the guard's data.
Place a button on your form that, when clicked, opens the report for the guard's name you selected in your list box.
Use the OpenReport method in the VBA code that comes with the On Click event of your button.
Add a filter / clause to the OpenReport method, referring to Access Help.
See to it that your report is based on a query.

Now if you follow this strategy, you can do with the minimum amount of reports generating as many filtered results as you'd like to.

Give it a try first yourself.

RV

 

[ScottGem]

The client wants and individual report on each guard so that the guard can see how many overtime hours he has worked. This program will be used in Kenya.

There are two ways to do this. You could do as RV suggested and filter each report for the guard. And you should have that capability if individual reports are requested for a specific guard.

For for your periodic report, that will be given to each guard, you create one report that is grouped on the guard. Configure the report so that a new page is generated after each group footer. In that way you have individualized reports for each guard run in one printout.

 

[drisconsult]

Hello RV and ScotGem
Spent most of the day yesterday looking up my old programs and found such a program I did two years ago.

Here I created a count query of all the relevant fields and used that in my Report. I then summarised the field that had counted the numbers of hours and multiplied that their hourly rate, and hey presto, I now have a report that list each Commander (of an armoured car) and his total overtime earnings for any given month.

Can't thank you both enough for forcing me to get my finger out and do some research. If you both don't mind I will send you a copy when it's finished.

Regards
Terence
London Monday 5 September 2005

 

[ScottGem]

You can defintiely do part of this in a query. But the issue I spoke about was more the design of the report once you got the data you wanted.

You can attach the database to a note here for us to look at if we want.

 

[drisconsult]

Hello RV and ScotGem

Am in Nairobi to see the family at the moment, when I get back to London I will send you the programs

Regards
Terence