I recently took on the volunteer position of Membership Chairman for a charitable organization. I purchased FM to use for mailing labels and membership lists. So far so good.

A simple problem I have is how to count, then print the number of records in a given report. I have no trouble sorting and filtering the records, then printing and distributing various lists, but I'll be darn if I can find a way to put the total records in the list at the bottom.

Any help would be much appreceated.

Hi,

If you want to count the number of records found in your report create a calculation field [result is number, unstored]

Status(CurrentFoundCount)

HTH

Thanks Andy,

Either I don't understand your reply, or perhaps it doesn't work for FM 5.5. I created a calculation field, result number...not sure about the "unstored" I think I found such a choice. I could not find anything like Status(CurrentFoundCount)

What I got was (in table view) a field (column) with a "1" in each records place in the field.

I know very little about this program, but it seems like what I'm asking for is basic. I could not even find a reference in the help or the manual.

I'm becoming disinchanted.

You must discourage easily, after all you did volunteer.

This does work in 5.5. If you go to "define fields" and create a calculation field, in the upper right corner or the window for defining the calculation you will see a drop down for selecting functions. Pull it down to "status functions" and the list will have Status(CurrentRecordNumber). You can also just type this in.

If you go to the help menu and do a find on "Status Functions", you will also find a complete list.

-bd