90 Day Forecast Reporting
I have completed my Asset Management Database and FileMaker Pro Advanced is Great. It was so easy to make my database with FileMaker but I now need to produce a 90 Day Forecast report on the 1st of every month which I have attempted to do with no success.
The report that I need to develop must detail the assets and in particular must give my customers a 90 day forecast of assets to be inspected and also must detail all the overdue items for inspection. I have tried to develop a report with the following fields for reference, "Inspection Due Date" & "No. of Days Remaining" but with my limited knowledge I have not been successful with programing the report to reflect what I need.
Can anyone help me or point me in the right direction to obtain the knowledge I need.
Thanks for your time in advance.