Re: BillMax questions -- Reports by zip code

["Leland J. Steinke" <steinkel@pa.net>]

Cibola Internet wrote:
> Hello,
>  
> Is there any way to create a report that divides customers into 
> categories by zip code?
>  
Are you looking for something like this?

servdef.name count by ZIP code:

SELECT user.zip, servdef.name, count(*) FROM user, service, servdef 
WHERE user.number = service.user AND service.servdef = servdef.number 
AND service.state IN (0,2) GROUP BY zip, name

Put it in a memorized report and you're done, unless that is not what 
you are asking.


Leland
-----------------------------------------------------------------------------
To unsubscribe from the "BillMax Questions" mailing list, please
send a message to "majordomo@billmax.com" with "unsubscribe questions"
in the message body. The message must be sent from the exact email
address on the list.