AnsweredAssumed Answered

Monthly Summery

Question asked by RogerBirch on Jun 15, 2016
Latest reply on Aug 10, 2016 by RogerBirch

I want to be able to see monthly totals for a set of records based on when my holiday clients depart. At the moment I have written a script for a button to create a table showing all income for (say) month of May, but the period of May is written within the script, i.e "Depart Date = */05/2016". Which is fine BUT if I want to see the totals for (say) April, I have to go into the script and change the script to read "Depart Date = */04/2016".

This seems unnecessary work and what I really want to be able to do, is to have a field on my database named "InvRange" that I can insert a search time, i.e "*/04/2016" and the script related to the button, looks at this field and gives me the result in my table.

So far I have been unable to create part of the script as "Depart Date = InvRange".

I am attaching a screen shot of the button script and Perform Find script.

Any suggestions will be gratefully received.