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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|