Help with Summary

[msylvester]

Please help this newbie! I wrote a FM 5.5 database for my business in 2001 and now I am rewriting it in FM 9. We organize group tours and the DB has a table for Groups, which is related to a table for Clients (i.e., individual members of each group) by a "Group Name" field.

On the Client table, there is a "status" field to note each client's status (Active, Canceled, etc). On the Group table, I want to summarize for each Group how many clients from that group are Active, Canceled, etc. I have been working on this for a week now and have made no progress! I see from other posts on this forum how to summarize this kind of thing for all records, but my need is to summarize for each unique Group.

Any and all suggestions will be gratefully accepted.

Michael

Edited August 6, 2008 by Guest

[Tim W]

Hi,

I notice that your profile says 9 advanced.

See if this thread helps:

Distribution function thread

HTH,

Tim

[msylvester]

Tim,

Thanks for the suggestion. I looked at the function and it seems to me that I will get back data from ALL records, not just the ones from a specific group. But I will give it a try and see what happens.

I really have enjoyed working in FM, but I am surprised that this one thing is not supported in FM directly. It would seem to be a useful function.

Michael