I have a database that tracks student tardies. All that works fine. The tardies are kept on a file server. Now I am working on a report that will show me the studentID, LastName, FirsName and the total tardies that they have. I know how to write the script to go to my layout but how do I keep the students from posting on my report that do not have tardies?

My student database tracks it using:

Count (Tardies::StudentID)

Produce the report from the Tardies table, using only a sub-summary (by StudentID) part.

Alternatively, find the students that do have tardies first.

Is there another way that I can get this done. I cannot seem to get the sub-summary to work. I can get the counts of the students but cannot filter out the ones that have a null value for the field of count. I have over 2500 students so I only need to see the ones that actually have a value in the count field.

Does this work for you?

Tardies2.zip

That is an excellent example. I cannot seem to get it to work on my program though. It gives me blank spaces and then when it does give me the count it gives me the student name 7 times with the number 7 beside each one if the student has 7 tardies. I am attaching an example so you can see what I did wrong. Thank you for the help so far.

TardyCalc_-_Forum.zip

Two points:

1. Examine the report layout in the example file: it has no body part, only a sub-summary (by StudentID) part.

2. The "blank spaces" are tardy records that do not have a related record in the Students table (e.g. tardies with StudentID = 182389).

BTW, which version are you using?

Thank you. I will look at it. I am using FileMaker Pro 11 advanced.

Thank you, it works now. That is what I needed to finish this program. Again thank you very much.