Query help

[chrislabs]

I have a table which lists player's stats yearly and a query thats pills from that table which
show the leaders in a particular stat year by year. Now is there is a
tie in the year the year shows up twice. for example:

1988 - playerID
1989 - playerID
1989 - playerID
1990 - playerID


But what I want is


1988 - playerID
1989 - playerID & playerID
1990 - playerID


is this possible???

 

[shudini]

Why would you want to do that? Why not create a report that would group based on year, and for each year it would show you any id that was returned in the query corresponding to that year. Wouldn't this be better?

 

[chrislabs]

i need a query so i can use it in frontpage