Search results

I kept playing with it and finally figured it out. Tks for your offer.

I did what you had told me and it worked. Thanks for the tip. However I forgot to mention one thing which I realized once I used the Select Distinct. My query had one more column Color so now my actual query looks like this ID Number Products color 122 Cups White 133 Pencils...

Thanks a lot I will try this

BlueIshDan Tks a lot:)

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