Counting distinct id's

[jqljql]

This is my first post so hello all.
I am new to access and need some help around counting distinct id's.



I need to count the number of distinct customer id's and also count the number of orders made.

Any help would be appreciated.

Thanks

[DanInManchester]

There is no count distinct in Access so you have to do a somewhat clunky work around a bit like this :

SELECT Count(ID) FROM
(SELECT DISTINT ID FROM tbl_Mytable) as myTable