Summary Calculation

[Yonal]

Dear friends,

I just very new in File Maker. Recently, i created a database contains bio data of students in our schools. It was around 6000 entry/student in the records. NOw, i got desperate when i need to count how many such as: male/female students, students with theirs tribes, and religion. For example: in my "Religion" field table contains entry: Islam, Buddha, Christian, Animist. How could i summarize how many are Islam, Buddha, Christian, Animist, etc.

Thanks in advance for your kindness

Yonal

[bcooney]

You need a subsummary report. Link

[Yonal]

Thanks a lot.

I will try working on it..

[Yonal]

Forgive me to ask more:

1. How to count the grand total, sub total for every field?

2. Is there any formula to count "length of service" which result year and month. For example: hire date: Sep 3rd, 2000. Length of service= 10 years, 4 months.

Thanks,

[bcooney]

1. You need a summary field that is the count of a unique value, typically the record's primary key: cnt_Records = Count (RecordID), type summary. If you place this field in a sub-summary part, you will get a subtotal by the break field defined in the sub-summary part. Place this field in the Trailing Grand Summary part, and you get a Grand Total.

2. See Custom Function Age

[Yonal]

Again,

Thanks a lot...

I am happy now!