Yes, this can be done using the Data Assist Search Wizard.
start by creating a recordset to join the orders and orderdetails tables on the results page, and use an order by clause to order the results by the office names, and sales reps columns.
Add the information you would like to display on the results page and the repeat region so that it will repeat through the recordset.
you can then use the Data Assist search wizard to create the search form to search the recordset you created by the data Range.