finding things

[postures]

As I look through the posts here, looks like it's mostly developers. If I'm in the wrong place, someone let me know?

I need to count things. I have a DB of hundreds of yoga poses. Ever record has, among many others, a field called 'Type'. This field is controlled by a value list. The value list is populated like this: Inversions, Forward Extensions, Back Bending, etc.

What I want to know is this: how can I determine how many Inversions are in a found set? Or how many Back Bends in a different found set?

I've experimented with summary functions but I am not getting anywhere.

Thanks!

[LaRetta]

Hi postures,

Attached is a simple example of how you use a summary in a report to count 'grouped' records. To use summaries, the record set must be sorted by the parts specified (see Layouts > Part Setup). There are two leading parts in this layout (the first is based upon a calculation called cMonthDate which turns the workout date into the first day of the month, making it easy to use for grouping records by month/year. The second leading part is based upon your Type field. You then place the same summary field in both parts, sort your records by those parts (in hierarchy order) and you are in business.

If you wish to only include some records in the report, such as only this year, perform a find first. I hope this is helpful. :^)

edit - File is fmp12 format

Exercises.zip

Edited June 30, 2012 by LaRetta