Support 805.461.7300
Sales
Our Technology. Your Success.

Create an Excel file with count by State

ON ERROR com_message=message()
SET SAFETY OFF
com_alias=alias()
alter table alias() add column stcnt N(10)
SELECT st, count (st) as stcnt ;
from (com_alias) group by 1 into table FORCEEXT(DBF(),"")+"-st_count"
USE (FORCEEXT(DBF(),"")+"-st_count") IN 0 ALIAS "merge"
SELECT("merge")
copy to FORCEEXT(DBF(),"") type xls
SELECT(com_alias)
USE IN IIF(USED("merge"),SELECT("merge"),0)

« Back to Commands

Just wanted to say THANKS!!!!!!! Great training session and I ran another list this afternoon, no issues!!!! You ROCK!!!! I am just so pleased with AccuZIP...Donna and Crissy are wonderful and everyone is so helpful! Very refreshing in these times!!! THANK YOU AGAIN!!!!
L.B., Englewood, FL