[MS_AccessPros] Dcount distinct function

 

Hi pro’s

 

I regularly use the count distinct function to get the number unique values of a variable.

Some SQl variants have  a Count distinct function but msaccess does not, as far as I know.

Actually I look for an adapted dcount function that counts the number of unique values in a column.

Has anyone created such a function before, and if so, Could you post it?

Thanks!

 

Onno Knol

 

__._,_.___

---

Posted by: "Knol, Onno" <Onno.Knol@pbl.nl>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

Visit Your Group

• New Members 3

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___