Totaling fields across records

[philipcaplan]

Hi!

I have a simple database for my own use, constructed in FMPro 8, with everything in one table (like an old-fashioned flat-file database!), in order to control an upcoming event I'm responsible for running.

I have a number of fields with either a numeric or an alphabetical value in them, and these obviously are present on every record.

Let us say that one of these fields is called "InviteReplyReceived" containing either a number 1 if a person has replied "Yes", a letter "x" if they've replied "No", and no entry if they haven't yet replied.

What I need is to display (on each record, I think) the total number of "1"s, "x's and "blanks", so that we can see the running totals of the three classes of replies.

Could some kind persons advise how best to do this, please?? Many thanks in advance.

[aldipalo]

Take a look at this file. I hope it helps. I'm sure I could have come up with something more elegant given some more time, but, it should put you in the right direction.

hth

RSVP.zip

[philipcaplan]

Many thanks, aldipalo.

That did the trick. For some reason, when I tried using a Summary field before, all the fields were grayed out. This time, the one I needed was available!

Thanks again, Philip Caplan