You can not become a scientist if you require that every question has an answer because its the very questions that have no answer that attract you to a laboratory every single day.
Scott, you could use one query to specify multiple criteria - even for the same field. Just keep the AND and OR conditions in mind (the OR rows). I cover this in detail in ACCESS 102 and I also know I talk about it in the Seminar as well.
If you want to build your own search routine, however, it will require a little VBA. I cover building a custom search button in Access 307. In an upcoming lesson, I'm going to cover building a more complex search form.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Microsoft Access Seminar.
