9. Set the Filter on the Master Query to apply to the Athlete ID field. This is how rows to be used from the master query will be located, matching the ID field. 10. Set the To Match field on the Sub Query to be the Athlete ID field. This will list all Athete ID values to be matched to 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 a certain date range. 12. Change the name of the Sub Query to Last Year. 13. Click Save to complete the Intersect. |