AnsweredAssumed Answered

summary by date

Question asked by buck_5648798798 on May 12, 2010
Latest reply on May 13, 2010 by buck_5648798798


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)"