Could one of you wonderful soles could write a couple of sql queries for me
I would be real grateful.
We need among others, 2 things.
1. We need total sub accounts by type subtotaled by city
Don't need to see each record, just # for each account type grouped and
totaled by city.
2. Same thing by Region
Doesn't have to print out in a report, just run in iSQL and report the info.
Thanks & really appreciated
JOhn :}
John C. Lange, Sr. PALACE dot NET, INC.
microjl@palacenet.net MICRO-TECH Computers, Inc.
608.742.1601 & 6980 2800 New Pinery Road
http://www.palacenet.net/ Portage, WI 53901
Visit our online store @ http://www.microt.com/
Authorized iPSwitch WebVar @ http://www.microt.com/iPSwitch/index.html
--- __o
--- _-\<,_ Fastest Service in Town
--- (_)/ (_)