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.