Access-seaching multiple records in a field

I am trying to set up a search function in Access 2003. Basically I have a table with 3 fields, Sample (e.g "01"), Site (e.g. "457"), and Base (e.g. "A")

I want to set up a query where the user can manually type in multiple sites and return the sample name that best fits/matches the search criteria. Not all samples will have the same number of 'sites'. I've tried a simple parameter value, but it only allows me to type in a single base, not multiple. I do have some experience with VBA so I could go that route if necessary.

If anyone has any help, I'd really appreciate it!

re: Access-seaching multiple records in a field

Do you know if there's an upper limit on how many sites they can choose?

re: Access-seaching multiple records in a field

No, not necessarily. Typically a sample could have anywhere from 10-60 sites.

re: Access-seaching multiple records in a field

You'll have to go through code. If you need the query then you can change the query's SQL through code. It depends on what you want to do with that query.