Apparently DISTINCT does not work in MS Acess, does anyone know of an alternate method for designing queries? Thanks.
It does work in most cases. The only problem I know is that
select count(distinct expr) from t
is not supported. This can be rewritten as
select count(expr) from (select distinct expr from t)
Could be somewhat more specific.
