Count distinct

[Anon]

I am using access w/ php and am trying to do the following.

select count( distinct SampleNo) from tblResponse where EID='$eid'

any help on how to do this.

Ace21