7 Replies Latest reply on Sep 22, 2009 6:40 PM by imgaryshap

    dates and subsummary reporting

    imgaryshap

      Title

      dates and subsummary reporting

      Post

      Hello

       

      I'm using FMP 8.0 on a Mac.

       

      I'm a novice users.

       

      When I sort my records by date, I want the sub-summary headline to group by month - year - and count of records in that month.  (i.e.  September 2009 - 35)

       

      what field / summary do i need to create to make that happen?

       

      right now - when i sort by date, the subsummary report puts the month header and record count on a per-day basis.  So for example -  if there were 5 records on September 10 and only 2 records on September 12, my report looks like the following:

       

      September 2009 - 5

      Record 1

      Record 2

      Record 3

      Record 4

      Record 5

       

      September 2009 - 2

      Record 6

      Record 7

       

      I want it to look like this:

       

      September 2009 - 7 

       

      Record 1

      Record 2... etc...

       

      Thanks!

       

      -Gary