Summation on entered date range

[aesi]

Hi There,

I'm new with FM10. I've created a data base to track daily Money Order sale. So everyday i enter the date and the sale of the day. i want to run an up to date total for that month and also look back previous month via enter two dates or enter the month. Please help.

thank you,

aesi

[mr_vodka]

It depends on how you want to view the data. If you want a report, you will want to create a subsummary report. You can create a new calculation field of:

Let ( d = YourSaleDate;

Date ( Month ( d ); 1; Year ( d ) ) ). Now group by this calc field ( your break field ) for your found set of records.

You can perform a find for your date range and then run the report. Do not forget to sort by your break field.

Edited February 15, 2010 by Guest
added more

[aesi]

Thank You John, now what would i do if i want to view the data on the same form view?

aesi

[mr_vodka]

You could use a calculation with GetSummary () or the easiest way of all is that you could just perform separate searches for the date ranges that you want. If you put the summary field on the layout it will always reflect the found set of records therefore it will total up for the date range that you want.