Counting and exclusions

[Guest]

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

 

[Jeff Boyce]

That would really depend on your data structure...

More info, please...

Jeff Boyce
<Access MVP>

 

[Guest]

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

 

[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>