Counting and exclusions

C

Curious

How do I get a count of an item without using duplicate order numbers? For
example, if I give a free mouse pad for every purchase of one of my software
packages, how do I prevent counting multiple mouse pads on the same order?
The customer is restricted to one mouse pad per order.



Thanks,

Sean
 
J

Jeff Boyce

That would really depend on your data structure...

More info, please...

Jeff Boyce
<Access MVP>
 
C

Curious

I have 6 fields as follows: Order#; Units; SKU#; Description; Total Weight;
Shipping Method. I need to count the number of times "Description" contains
"Free Mouse Pad" but not if it has the same Order#. Does that make sense?

Thanks,
Sean
 
J

Jeff Boyce

If you GroupBy [Order#], WHERE [Description] = "Free Mouse Pad", I think
you'd get it.

Take a look at the Totals query...

Good luck

Jeff Boyce
<Access MVP>
 
Top