9. Set the Filter on the Master Query to apply to the Athlete ID field. This is how rows to be removed from the master query will be located, matching the ID field. 10. Set the Exclude field on the Sub Query to be the Athlete ID field. This will list all Athete ID values to be removed from the master query. 11. Drag the Year field into the Sub Query Filters list. This will be used to restrict the list of Athlete IDs to remove to a certain date range. Important: You must add any filters to your Minus Subquery before adding filters to the Master Query. If you do not, you may not see filter values in the Master Query. 12. Change the name of the Sub Query to Prior Years and the description to Remove all customers from previous years to create a list of new customers for the current year. 13. Click Save to complete the Minus. |