Compare a set of found records (same records in two date ranges)
Ok guys! :)
I am using FMP 11 Pro Advanced. Mac OS X 10.6.3.
I have a database of a budget for a company I manage, the budget is dynamic (I enter the expenses, assign their expense codes and the budget decreases for that amount, providing information about the planned and currently spent budget allowing me to monitor any deviations).
When I create reports, I usually create reports for the quarters, and there is a need for me to match the records of the current quarter with the ones from the previous quarter. When I create my report I use a search string with the date range and I get the relevant information.
My question now is: How could I get filemaker to show 2 separate data sets with two ranges, and maybe even calculate the difference between those two?