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) |
