Query to select unique seasons

[Rustywater]

Hi,

Could someone please tell me what the select statement for MSACCESS would be
to select the number of times a player appears in the following table, where
the season is unique. Eg. If a player plays in two teams in one season we only
want to count that row once....


Player / team / season
1 / 1 / 1
1 / 2 / 1
2 / 1 / 1
3 / 1 / 1
1 / 1 / 2
2 / 1 / 2
2 / 2 / 2

In the above, player one plays in 2 seasons (this is the result I'm after),
but played in 3 teams over the two seasons.

thanks
Tanya

[gwgiswebmaster]

SELECT COUNT(DISTINCT Season) WHERE Player = [your value here]

[Rustywater]

I had actually tried that, as well as just SELECT COUNT(season) from players
where player=#player#, which only ever returns a value of 1. But when trying
the above suggestion script dies with "Syntax error (missing operator) in query
expression 'COUNT(DISTINCT season)'. "

Tanya

[Rustywater]

This works..

select DISTINCT <column> from <table> where <x> = <y>