4 Replies Latest reply on May 13, 2010 12:47 PM by buck_5648798798

    summary by date



      summary by date


      I'm using FM 10, Mac 10.6.3


      I'm working on an invoice system and I want to see how much was earned by month.


      I have a simple layout with Work Date, Total $ and a summary field that adds it all up.


      If I do a find for "2/*/10" I'll get February's total so that is ok, but clunky.


      Is there a way to create a calculation field for each month that does this for me? Something like "total february = (mysummaryfield) within a date range (2/1/10-2/28/10)"