Help With Report - Please!

[optimus_1]

Hello All.

I am trying to create a report from the data in the tables and am struggling!.

I have attached a DB with sample data. I am trying to produce a report from this data that only returns certain criteria.

From the data in the tables i want to produce a list of all 'Operatives' that exceed '100 points per day'. This will be clear once tables have been viewed.

I can achieve this but with my limited knowledge there is a problem that i cant overcome:
1) Operatives may work on more than one tool each day hence the daily sum COULD be for 2 or more tool.

The report i am looking for should look similar to this:

Name Tool W/Ending Day Points
A.Bloggs Strimmer 08/11/08 Monday 170
TOTAL: 170

J.Bloggs Strimmer 11/11/08 Tuesday 111
J.Bloggs Chainsaw 11/11/08 Tuesday 40
TOTAL: 151

Z.Bloggs Pruner 25/11/08 Thursday 138
Z.Bloggs Chainsaw 25/11/08 Thursday 50
Z.Bloggs Blower 25/11/08 Thursday 340
TOTAL: 528

ETC....

Hope this makes some sense to someone! If further information is required please ask.

Thankyou in advance for help.

Nathan

 

[Premy]

Well I took a quick glance:

1. in the report query, replace tblOperatingTool.Description by tblMain.[Tools Input 1]

2. On the report change the source for Tools to Tools Input 1

3. Move the controls "Tools" and "Week Commencing" to the details section and delete their respective group headers: just keep the Name Group header. To remove the group headers, right click the report header, choose Classify and Group, select the lines for tools and week commencing, and click "No" next to "Group Header" in the lower part of the dialog.

If I could make a suggestion here I'd say you should use change the field Tools Input 1 in tblMain to a Foreign Key field for ID from tblOperatingTool. This will introduce much more consistency into your DB.

HTH

 

[optimus_1]

Hi

Thanks for that, it helped.

One of my objectives is to highlight and person who exceeds 100 'points' per day.

I have been scratching around with it and i think i need to exclude the 'tool' part of the report to achieve this. I can do this but i am struggling with adding the two figures together (if there are two tools used on that day) etc.

I have attached my updated version.

Do you know how i can achieve this?.

Many thanks in advance
Nathan