[AccessD] MOre help needed

I have a parameter query that exports a table to Excel.  I want the query to
pull the parameter from a field in another table (tblschools).  How do I do
that so that when I run the query it will export a separate spreadsheet for
every record in tblschools?