[AccessD] A2000: Am I blind? (swe)

John,

Well, yah! Like, I did that, eh? Thought you'd get away with an easy
answer, didn't ya?

Seriously, I wasn't aware until Gustav mentioned it that I can use a
subquery in the FROM clause. T-SQL has a COUNT DISTINCT, but nothing
like that in Access.

Thanks, John.

Steve Erbach
Neenah, WI


On Sat, 12 Feb 2005 08:27:30 -0500, John W. Colby
<jwcolby at colbyconsulting.com> wrote:
> SELECT DISTINCT State from tblXXXX
> 
> John W. Colby
> www.ColbyConsulting.com