Support 805.461.7300
Sales
Our Technology. Your Success.

Count marked records and fill count into another field

This command can take the total number of times a given value is in a field, and put the count into another field. In the example below, if you have 50 marked records, it'll put the number 50 into field1 for every marked record.

PUBLIC com_Count
SET TALK OFF
COUNT FOR !EMPTY(x) TO com_Count
REPLACE field1 WITH ALLT(STR(com_Count)) FOR !EMPTY(x)

For the sake of looking at a specific value in a field, you could change the last two lines of the command to:
COUNT FOR "X" $ x TO com_Count
REPLACE field1 WITH ALLT(STR(com_Count)) FOR "X" $ x 

If field1 is a Numeric type field, change the last line of the command to read:

REPLACE field1 WITH com_Count FOR !EMPTY(x)

« Back to Commands

I wanted to drop you a line to tell you that working with Accuzip has been a breath of fresh air. I’ve been able to speak with a Live person each and every time I call. Your unlimited Tech Support, Personal Training and Price Lock Guarantee has given me the confidence that I made the right choice. Accuzip was able to solve my list issues and add value to my existing database at a more than reasonable price.
J.S., Newark, OH