Filtering a Summary Portal with Date Range Options

File uploaded by larealtor on Apr 23, 2017
Version 1Show Document
  • View in full screen mode

Hi FM Pros...your assistance and suggestions would be much appreciated. I adapted the attached file, circulated in the FM community some time ago as an excellent example of using filters in a portal as an alternative to sub-summary layouts, for use in my real estate database.  I now want to add additional filters. Specifically, I want to create START DATE and END DATE fields in the EXPENSES TABLE (to be placed on the Expenses Layout) to filter data in the RECEIPTS PORTAL so that it shows (in the RECEIPTS SUMMARY PORTAL) data that is applicable to the selected DATE RANGE.  I look forward to your feedback. Thanks much.