I have two tables:
(TblOne) contains multiple (CompetitorID), (Race Date) & the (Race Finishing Position) on that date, sorted by race Date.
(TblTwo) contains all the years (Single Race Dates) and the (No of Competitors) for each RaceDate, sorted by Race Date.
Race Dates have an inner join from TblOne to TblTwo.
A Form is used to obtain the CompetitorsID from a single selected item listbox. This works OK.
For the Report I want to display by CompetitorID (The Report Heading) and then columns to show RaceDate, No of Entries, Race finishing Position.
I actually have two more columns which are calculated using ‘No of Entries’ & ‘Race Finishing Position’
Could anyone help with:
The writing of the Select Query please &
Can I do calculations within the report column Control Source?
Many thanks
Pat
(TblOne) contains multiple (CompetitorID), (Race Date) & the (Race Finishing Position) on that date, sorted by race Date.
(TblTwo) contains all the years (Single Race Dates) and the (No of Competitors) for each RaceDate, sorted by Race Date.
Race Dates have an inner join from TblOne to TblTwo.
A Form is used to obtain the CompetitorsID from a single selected item listbox. This works OK.
For the Report I want to display by CompetitorID (The Report Heading) and then columns to show RaceDate, No of Entries, Race finishing Position.
I actually have two more columns which are calculated using ‘No of Entries’ & ‘Race Finishing Position’
Could anyone help with:
The writing of the Select Query please &
Can I do calculations within the report column Control Source?
Many thanks
Pat