I thought this would be really simple, BUT. I have a membership database in a single file. One of the fields is "Sex," with either a "F" or a "M." I would like to create a field that counts each and displays a running total for various sorts that I make. I've looked through many of the posts here and most provide a somewhat complex solution for what seems very simple.

Steve

Hi Peter,

Here's an example. First approach uses Sum() to produce your results.

Second approach produces a report (taking advantage of summary). You can have total per group.

LaRetta

There is something wrong LaRetta the number of males follows the number of females, but changes only when somone of the other gender is the found record.

I've made a templat that changes live according to the chosen gender.

--sd

Gender.zip

Thank you to both of you, but I'm running FM6. I can not open thes files. Any chance you can save them for 6?

Steve