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