Count the occurances of a data value

[pschatz100]

I have a database that stores membership information for my club. I ca
export member information as a .csv file, and would like to create
report that uses mailmerge to print selected member information
including a count of the member types (active, expired, etc.) Fo
instance, using the .csv file as a data source I would print a list o
new members, plus a count of the total number of active members.

I can already read through the list of members, and using an I
conditional, just print the ones that are new members. Pretty cool

 

[Peter Jamieson]

Counting them is relatively easy - something like

{ IF { MERGESEQ } = 1 "{ SET mycount 1 }" "{ SET mycount { ={ REF
mycount }+1 } }" }

should do it.

The real difficulty is that there is no easy way to tell that you are
merging the /last/ record so that you can then output the count.

In this case, one way to work around that would be to
a. output to a new document
b. output the count for every record in a format that is easily found using
Find/Replace. For example, you could output

##{ REF mycount }##

c. after the merge, delete the ## characters surrounding the final count,
then use Edit Replace to replace "##(*)##" by "\1" (leave out the "
characters, click the "More" button in the dialog box, and check the Use
wildcards option.

Peter Jamieson

 

[pschatz100]

Peter,

Thanks. the counting works great. People like you make this stuf
look easy!