By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,984 Members | 1,461 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,984 IT Pros & Developers. It's quick & easy.

Access-seaching multiple records in a field

P: 2
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")

Expand|Select|Wrap|Line Numbers
  1. Sample       Site        Base
  2. 01              457            A
  3. 01              6579          G
  4. 01              7864          C
  5. 02              64              T
  6. 02              6579          G
  7. 02              16519        C
  8. 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!
Feb 27 '07 #1
Share this Question
Share on Google+
3 Replies

Expert Mod 10K+
P: 12,349
Do you know if there's an upper limit on how many sites they can choose?
Feb 27 '07 #2

P: 2
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.
Feb 27 '07 #3

Expert Mod 10K+
P: 12,349
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.
Feb 27 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.