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

We have over 200 vendors we work with on a daily basis and (the AccuZIP6 techs) are the most knowledgable, helpful group of folks I have worked with, always willing to go out of the way to help. As owner and GM of a Print and Mail Shop I admire the dedication these folks have in making sure we are satisfied. I also appreciate the fact that a human answers the phone.

M.S., Mt. Vernon, IL