Count of Customers

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

Guest

I want to be able to count the number of customers a praticular store had. How do I count the number of customers counting each customer only once if they bought more than once in a month.
 
George

This will really depend on what data you store. What's your table
structure?

More info, please...

Jeff Boyce
<Access MVP>
 
My table is as such. I have a table that houses all my salesorders. It includes sales ordernumber,sku, description.,quantity,price,ext,descrip.,line number. What I want to be able to do is count the number of orders counting each order only once. An order number can appear several times because each can have multiple line numbers.
 
George

So, instead of having a table of order information, and another table of
line item information, you have it all combined into one? That sounds like
a spreadsheet, not a database.

If you had a more normalized data structure (one table for orders, a "many"
table of related line items), you could simply use Count() on the order
table.

If you build a query that returns the unique order numbers (UniqueValue
property = Yes), then build a second "totals" query on the first one, you
can Count() the number of unique order numbers.

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top