What you need to create is a parameteric query. This can be easily done for mroe than one parameter. When you do this you will supply the paramer at run time. If you want you can also web enable using what are called Data Access Pages.
Try the link , All you wanted to know about MS Access at the following link:
Hodentek