How to get a customer count by zip code report

(Last updated on: October 2, 2015)

  • Go to Mailing list | Generate a mailing list | Export email
  • Click the Edit the query tab

edit the query 3

COPY AND PASTE THE QUERY BELOW into the Edit the query field:

select sum(total_tix) as tickets, sum(total_sale) as sales, left(zip,5) as zip, count(customer.customer_id) as customers
from mainsale
          left join customer using(customer_id)                                                                                      group by left(zip,3)
order by zip

Here is an example of the report:

zip report

This entry was posted in Desktop Software, Reports, Wintix5 and tagged . Bookmark the permalink.

Leave a Reply