Counting and exclusions

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
That would really depend on your data structure...

More info, please...

Jeff Boyce
<Access MVP>
 
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
 
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>
 
Back
Top