AboutRichard Rost Expertise I am happy to answer any kinds of questions about Microsoft Access - from basic table design to advanced VBA programming. Also, please feel free to check the Access Tips & Tricks section of my web site.
Education/Credentials I am a self-taught Access expert. I have been building databases for clients since the early 90s. You can see a sample of my Access Tutorials on my web site at 599CD.com
Question I need a Parameter Query to accept more than one entry so i can have it return the resuls for several records. The data, (test number) in the field i am searching on is unique to each record. It would need to ask to enter the test numbers, i.e. 1021, 1011, 1065.
Thanks.
Answer I would do this as a form.
Make a form with the most number of text boxes that you think you would ever need as parameters, and then refer to them in your query as in the following tutorial:
If you want to refer to a value on a Form, you can use the notation:
Forms!FormName!FieldName
You can use this notation inside of queries, other forms, or even reports. I have a free tutorial that explains how to use this:
P.P.S. I volunteer my time at AllExperts to help people, and I get a LOT of questions, so I can't take an hour to answer each question. If you need more DETAILED HELP, come to my TechHelp web site at http://www.599cd.com/TechHelp/AllExperts and I'll take as much time as you need to answer your question.
