I'm sure this one has been asked time and time again!

I currently have a set of staff questionairres each on a different table.
Currently when I want to export all the scores for one employee to excel (eventually) I have a macro which runs 7 queries, but each asks for the same criteria (Date To & From) and (Staff Name) in turn - very time consuming!

How do I create a query or macro which will ask once for a date range and an employee name and apply to all of my queries?

I am a novice on access and am trying to do this without SQL

Thanks for your help

Have the user input the criteria into form controls and have your queries all look to the form controls. Instead of this in the query

[Enter date]

you'll have this

Forms!FormName.ControlName