Access-seaching multiple records in a field

[lynn80]

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")

Sample       Site        Base
01              457            A
01              6579          G
01              7864          C
02              64              T
02              6579          G
02              16519        C
etc...

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!

[Rabbit]

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

[lynn80]

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

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

[Rabbit]

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.