Prev: Update - Microsoft Responds to the Evolution of Community
Next: Crosstab Report
From: Duane Hookom on 10 May 2010 12:27
I don't understand your table structures. I don't know if they are normalized
or not. The solutions both Marsh and I have suggested should work for
displaying data in your report.

--
Duane Hookom
Microsoft Access MVP


"neil40(a)btinternet.com" wrote:

> On 10 May, 15:57, Duane Hookom <duanehookom(a)NO_SPAMhotmail.com> wrote:
> > You haven't suggested the relationship between the two tables. If it is one
> > to many than you can use a query that joins the tables as the record source.
> > If you have many to many, you need to use a subreport to display one of the
> > "many" tables. This subreport would be located in a group header or footer
> > for the common field.
> >
> > --
> > Duane Hookom
> > Microsoft Access MVP
> >
> >
> >
> > "nei...(a)btinternet.com" wrote:
> > > Hi
> >
> > > Just wanted to get some advice before I attempt to make a report that
> > > will use 2 tables as source material.
> >
> > > Basically, my database stores information on a sport.
> > > One table is a list of teams and their historical venues/successes etc
> > > The second table is a list of the teams annual results.
> >
> > > The report I want to make will be a page per team report, that at the
> > > top shows the data from the 'venues' table, so where there are more
> > > than one venue, it would need to 'loop' through the table to show all
> > > venues
> > > As far as the 'successes' (League Championships/cup wins etc) goes, I
> > > wouldn't want that in the loop! (IE only show it once per team.
> > > Below this venue and successes data, I want to show the annual results
> > > from the second table.
> >
> > > This is where I would value this groups advice.
> > > Do I need to link the tables using relationships, and have the second
> > > section as a sub-report of the first?
> >
> > > Many thanks
> > > Neil
> > > .- Hide quoted text -
> >
> > - Show quoted text -
>
> The common field will be the team name, and yes, there are many
> occurences in the results table - one per year generally, and as
> mentioned, if the team moved venue, then in the first table (venues/
> successes), there will also be 'many'
>
> I've a thought to make a 3rd table and split out the trophies bit
> (successes) so that the venues is purely stadium/track data
>
> Would the report still work with 3 tables? I presume it's then just
> about the relationship with many to many joins?
>
> Neil
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: Update - Microsoft Responds to the Evolution of Community
Next: Crosstab Report