sql - MS ACCESS: How can i count distinct value using access query? - Stack Overflow

try select ..., count(distinct Training.Tcode) as ..., ... EDIT - please now look at this... Take the following SQL code. The first select is how SQL server would do this and the second query should be access compliant... declare @t table (eCode int, tcod

stackoverflow.com