I have a simple report which looks as given below:
ID Number Products
122 Cups
133 Pencils
122 Cups
133 Pencils
When I use the count function I get the total count of the record as 4
what I want is count the product varieties which should...
I am an ameture access freak. I try to do different things with access and I always get help at this forum when I get stuck. So today I decied to join the group.
Thanks for your help.:D