[AccessD] Counting Co IDs

Susan Harkins ssharkins at gmail.com
Mon Nov 5 09:36:02 CST 2007


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




More information about the AccessD mailing list