Gustav Brock
Gustav at cactus.dk
Mon Nov 5 11:50:19 CST 2007
Hi Susan This is MS SQL Server or MySQL syntax. Unfortunately, it doesn't work in any version of JET SQL. /gustav >>> ssharkins at gmail.com 05-11-2007 16:36:02 >>> Well that's cool -- I'll have to take a look at that one! Susan H. > Not that you need it in this case, but it's worth mentioning a seldom-used > flavor of the Count() syntax. Here's one that works against the > AdventureWorks sample database: > > Select Count(Distinct CustomerID) from Sales.SalesOrderHeader