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

As always, thanks for your product. We in the industry TRULY appreciate the fact that YOU get back to us. You have NO IDEA how important that is.
T.G., Berlin, MD