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)

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

New to the
Mailing
Industry?
More Info

Professional Services
More Info

Vince [in support] took the time and spent about 2 hours on the phone with me as we walked through an issue and figured out the problem. To me he went above and beyond normal support and really thought outside the box to figure out the solution. Thank you again Vince for all your help.

M.K., Aurora, IL