S ScottXe Registered User. Local time Tomorrow, 05:16 Joined Jul 22, 2012 Messages 123 Nov 22, 2014 #1 I would like to count distinct values on a control in the footer of a search form. Can someone guide me how to accomplish it. Thanks!
I would like to count distinct values on a control in the footer of a search form. Can someone guide me how to accomplish it. Thanks!
B burrina Registered User. Local time Today, 15:16 Joined May 10, 2014 Messages 972 Nov 23, 2014 #2 Take a look at this link. https://support.office.com/en-sg/article/DCount-function-counts-the-unique-values-in-a-record-set-227efeeb-5bb3-4343-8277-a0750daf3496
Take a look at this link. https://support.office.com/en-sg/article/DCount-function-counts-the-unique-values-in-a-record-set-227efeeb-5bb3-4343-8277-a0750daf3496
S ScottXe Registered User. Local time Tomorrow, 05:16 Joined Jul 22, 2012 Messages 123 Nov 24, 2014 #3 Hi Burrina, Thanks for your pointer. It looks to fit in my situation but no luck to resolve it.
