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

Hi Steve

Yes, T-SQL is another animal.

/gustav


>>> erbachs at gmail.com 13-02-2005 15:25:46 >>>
Gustav,

Interesting. I've used subqueries many times as Criteria, but never in
the FROM clause. It works.

My curiosity is aroused by what I found in the MSDN help files. Namely
that T-SQL has a COUNT DISTINCT command. Of course, that doesn't
translate to Access except that one does the kind of thing you
suggested.