Query output in a different format

  • Thread starter Thread starter Sean
  • Start date Start date
S

Sean

I am trying to write a query that will display the
performance of golfers from one tournament to the next.

Instead of the data being displayed in the following
format:
NAME TOURNAMENT DATE POSITION
GolferName1 TournamentA Date 1
GolferName1 TournamentB Date 19
GolferName2 TournamentA Date 3
GolferName2 TournamentB Date 4

I would like to generate a query that displays the data
like this
GolferName1 1,19
GolferName2 3,4

i.e.showing a line for each golfer with his name in one
cell and the finishing positions for all his tournaments
in another cell (separated by commas and in chronological
order).

Any ideas anyone ?

Thanks
 
Why not create a simple query that returns every game a player has played.
Something like :

Select Player_Name, Fin_Position From Table.

You can then use VBA to create a string containing the player name and the
finishing positions of all his games from the recordset returned.
 
Back
Top