This script quickly finds all students that are learning MORE THAN ONE instrument and displays them in a list that you can print or save as an excel file.
1. Firstly, it will take you to the Tuition List screen and pause for you to confirm or modify the find request.
Note: The field that is used in this find request is not visible on this screen, however it doesn't need to be. It's the 'Total Tuition' field and the search criteria is '>1'. If you wish to modify the find request (for example, if you need to specify a Campus), add this data to the request.
2. Click 'Continue' at the top right of the status area to resume the script.
3. The records will be found and displayed in preview mode. You can print this list by selecting the Print button in the status area. Click 'Continue' to return to the Common Tasks screen.
4. If you wish to save the records as an Excel spreadsheet (perhaps to use the data as a Mail Merge source), select 'Cancel' to halt the script. The screen will change to Browse mode and you will be able to see some additional hidden fields (including postal address information). Select 'File' from the menu at the top of your screen, and then 'Save/send records as Excel'.
To return to the Common Tasks screen, click the 'Close Window' button.