3 Replies Latest reply on Mar 10, 2009 5:13 PM by comment_1

    Status/Summary Report

    David40

      Title

      Status/Summary Report

      Post

      I have a database that tracks historical events by month, day, and year.  I would like to produce a summary report that shows the total number of events for each day of the year. 

        • 1. Re: Status/Summary Report
          deltatango
            

          just do a sort based on date field.

           

          your event layout should have a subsummary section for when sorted by event date

          then a body section where you put the event fields data

           

          then sort by date and enter preview mode 

          • 2. Re: Status/Summary Report
            David40
              

            Thank you for your suggestion, but if I understand it correctly, I am doing that now. I have to do 366 separate searches in order to get the total number of events per day.  I would like to create a script that produces a report that shows those results.  Its similar to searching a phone book to see how many "A's", "B's", etc., there are.  I don't need the data, just a number.

             

            I am very new to FMP and have taught myself the program.  I am sill learning.  Thank you for your patience. 

            • 3. Re: Status/Summary Report
              comment_1
                 Define a summary field as Count of <any field that cannot be empty>. Place that field in the sub-summary by date part. If you like, you can delete the body part of the layout, so you'll get a summary report only.