Newbies Yonal Posted January 26, 2011 Newbies Posted January 26, 2011 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
Newbies Yonal Posted January 28, 2011 Author Newbies Posted January 28, 2011 Thanks a lot. I will try working on it..
Newbies Yonal Posted January 28, 2011 Author Newbies Posted January 28, 2011 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 Posted January 28, 2011 Posted January 28, 2011 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
Newbies Yonal Posted February 1, 2011 Author Newbies Posted February 1, 2011 Again, Thanks a lot... I am happy now!
Recommended Posts
This topic is 5044 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now