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