C
Clint
I know my subject sounds like jumbo, but it really is quite a simple
idea.(obviously not too simple). I am running a query that is already
grouped by the first 3 letters of a postal code field. I need to know
the amount of customers that each group of Postal Codes has. The
problem is that some customers have multiple invoices so I can't just
count them because customers with 2 invoices will be called two
customers. So, I ran a query that put customers and their purchases
into on entry, meaning that their number will only count once. When I
put that field into this query it creates a new problem. If one Postal
Code has 3 customers and their numbers are 6, 8, and 10, the total
will come as 24. How do I change that.
idea.(obviously not too simple). I am running a query that is already
grouped by the first 3 letters of a postal code field. I need to know
the amount of customers that each group of Postal Codes has. The
problem is that some customers have multiple invoices so I can't just
count them because customers with 2 invoices will be called two
customers. So, I ran a query that put customers and their purchases
into on entry, meaning that their number will only count once. When I
put that field into this query it creates a new problem. If one Postal
Code has 3 customers and their numbers are 6, 8, and 10, the total
will come as 24. How do I change that.