A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Report on multiple venues for same team



 
 
Thread Tools Display Modes
  #1  
Old April 23rd, 2010, 05:40 PM posted to microsoft.public.access.reports
[email protected]
external usenet poster
 
Posts: 60
Default Report on multiple venues for same team

Hi

My database has records of a sports teams and results.
I create reports of League standings over several years, and also a
'per team' report, that gives their venue, years they operated etc,
and below this are their year by year results

One problem I am facing is where some teams have operated from several
venues. My 'teams' database table has recorded this, and accordingly
when I create the yearly table, I pick the team using a drop down list
that shows several columns so I pick the correct venue.
However, as they are essentially the same team, but could have
operated from 3 or 4 venues (or more in some cases), I want the
summary report to just show 1 team name, but (hopefully) all venues,
and results.
Initially the report seems to loop through for the number of instances
of the team in the team db table and repeats the result
EG Team 'A' has had 4 venues, in the results section I have 4 lines
for every year.
It's almost like I need a 'Hide Duplicates' effect

I'd like some advice on the best way I can achieve this

Many thanks
Neil
  #2  
Old April 23rd, 2010, 06:23 PM posted to microsoft.public.access.reports
KARL DEWEY
external usenet poster
 
Posts: 10,767
Default Report on multiple venues for same team

You need to post table and field names with datatype along with sample data
for someone to be able to follow what you are asking.
--
Build a little, test a little.


" wrote:

Hi

My database has records of a sports teams and results.
I create reports of League standings over several years, and also a
'per team' report, that gives their venue, years they operated etc,
and below this are their year by year results

One problem I am facing is where some teams have operated from several
venues. My 'teams' database table has recorded this, and accordingly
when I create the yearly table, I pick the team using a drop down list
that shows several columns so I pick the correct venue.
However, as they are essentially the same team, but could have
operated from 3 or 4 venues (or more in some cases), I want the
summary report to just show 1 team name, but (hopefully) all venues,
and results.
Initially the report seems to loop through for the number of instances
of the team in the team db table and repeats the result
EG Team 'A' has had 4 venues, in the results section I have 4 lines
for every year.
It's almost like I need a 'Hide Duplicates' effect

I'd like some advice on the best way I can achieve this

Many thanks
Neil
.

  #3  
Old April 24th, 2010, 12:30 AM posted to microsoft.public.access.reports
[email protected]
external usenet poster
 
Posts: 60
Default Report on multiple venues for same team

On 23 Apr, 18:23, KARL DEWEY
wrote:
You need to post table and field names with datatype along with sample data
for someone to be able to follow what you are asking.
--
Build a little, test a little.



" wrote:
Hi


My database has records of a sports teams and results.
I create reports of League standings over several years, and also a
'per team' report, that gives their venue, years they operated etc,
and below this are their year by year results


One problem I am facing is where some teams have operated from several
venues. My 'teams' database table has recorded this, and accordingly
when I create the yearly table, I pick the team using a drop down list
that shows several columns so I pick the correct venue.
However, as they are essentially the same team, but could have
operated from 3 or 4 venues (or more in some cases), I want the
summary report to just show 1 team name, but (hopefully) all venues,
and results.
Initially the report seems to loop through for the number of instances
of the team in the team db table and repeats the result
EG Team 'A' has had 4 venues, in the results section I have 4 lines
for every year.
It's almost like I need a 'Hide Duplicates' effect


I'd like some advice on the best way I can achieve this


Many thanks
Neil
.- Hide quoted text -


- Show quoted text -


OK

I have Tables:
tblteams - this has the Team data (stadium, years of operation, awards
etc) - as mentioned, this has some teams multiple times for when they
moved to different stadia
tblseason - Has details per year of the Leagues in operation
tbltest - an amalgamation of the above and with extra fields. This
records the year by year (not match by match) results of teams (I have
a report that produces year by year League Tables), so records Year
(drop down list referenced to tblseason), League (an after event of
Year choice), Team (from tblteams via drop down), then Won/Drawn/Lost/
For/Against/Points

My 'Team Report' - the subject of this posting - has:
Team Header - prints team name, nickname, Stadium, address, awards etc
There is a header that sorts out results Pre and Post World War 2
Detail Section - year by year results for this team (Played/Won/Drawn/
Lost/For/Against/Points
Team Footer - Sums of the Detail section

Grouping:
Group on Team with A on top
Group on Expression (=[Season]1945) ascending
Sort by Season

So, in the Team Header, where there is a team name repeated several
times at various stadia, I'd like to be able to show all stadium
details if possible

Currently, with this scenario, in the Detail Section I am getting (for
example with a Team that had 4 stadium moves
Year League P W D L F A Pts
1929 "League 1" 26 13 2 11 650 455 28
Above line repeated 3 more times
then 4 lines per each season recorded for this team

Need to reduce this to 1 line per season of course

Hope this is enough to explain it more

Neil
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:35 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.