AnsweredAssumed Answered

Converion from Access to Filemaker

Question asked by PaulCarpenter on Jul 8, 2015
Latest reply on Jul 8, 2015 by philmodjunk

Title

Converion from Access to Filemaker

Post

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.

Untitled-1.png

Outcomes