AnsweredAssumed Answered

Yearly reports

Question asked by beachgrrrl on Feb 19, 2013
Latest reply on Feb 20, 2013 by philmodjunk


Yearly reports


     I am new to FileMaker - I have been using Bento since the days of Bento 1.0 to manage my website design business. However I have just got a new PC and hence the switch to FileMaker. I have managed to copy all my Bento tables and load them into FileMaker and make the relationships between the tables.

     However, In Bento I have a table for Sales where I keep track of invoices, and below it I have Collections for Sales 2011, Sales 2012, etc. I cannot figure out how to make this happen in FileMaker. I did ceate a Layout which is quite lovely with Monthly subtotals, but it seems to report on the whole table - I can't find a way to limit it to one year only.

     Please advise what is the best way to accomplish this.