Darrell
Registered User.
- Local time
- Today, 09:19
- Joined
- Feb 1, 2001
- Messages
- 299
I am the manager of one of the local football teams and as such provide a report every week of the results etc.
One of these reports is specifc to our team where it reports the following info by week for the season.
Date (of game played)
Vs (opposition)
Goals for
Goals Against
Player of Day
Goal Scorers
No of goals by scorer
All of this is entered in one form, with the POD and the scorers entered into individual subforms.
The report is based on a query which has the three tables linked by Date, and the feilds Date, Vs, For, Against and POD have the Hide Duplicates property set to yes.
So a given week may look like this
Date------Vs--------For--Against----POD----Scorer---# of Goals
28/06/03...Taradale.....3........0..............dh........dh...........1
...................................................................js.............1
...................................................................qm...........1
Now this has worked fine for me for a long time now until last weekend when our coach decided that the POD was the whole team, meaning that 14 players need to be listed under POD.
As you can imagine the query now has 14 different people listed for each goal scorer and it really has made a mess of things.
What I would like to know is is there another way of doing this query or any other advice to report this situation.
Thanks
dh
One of these reports is specifc to our team where it reports the following info by week for the season.
Date (of game played)
Vs (opposition)
Goals for
Goals Against
Player of Day
Goal Scorers
No of goals by scorer
All of this is entered in one form, with the POD and the scorers entered into individual subforms.
The report is based on a query which has the three tables linked by Date, and the feilds Date, Vs, For, Against and POD have the Hide Duplicates property set to yes.
So a given week may look like this
Date------Vs--------For--Against----POD----Scorer---# of Goals
28/06/03...Taradale.....3........0..............dh........dh...........1
...................................................................js.............1
...................................................................qm...........1
Now this has worked fine for me for a long time now until last weekend when our coach decided that the POD was the whole team, meaning that 14 players need to be listed under POD.
As you can imagine the query now has 14 different people listed for each goal scorer and it really has made a mess of things.
What I would like to know is is there another way of doing this query or any other advice to report this situation.
Thanks
dh