Converion from Access to Filemaker
I am in the process of converting from MS Access to Filemaker, and would be very grateful if anybody could let me know the most efficient way to replicate the following Access solution.
The purpose of this query is to split the transactions from a table into ‘fiscal years’ then to be able to output them to give ammounts spent by year.
This query uses the output of other queries rather than using tables directly.
I have identified a way of replicating this in Filemaker by finding records for each fiscal year and exporting them to a table which can then be reused.