Select Query with Parameters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a select query that I need to add parameters to but I'm not sure how.
For one of my controls I have choice to enter either "Internal" or
"External". When I run the query I use a form to make my selection from a
combo box. How can I add a third choice as "All"? So I could either select
"Internal", "External", or "All". When I select "All" I want it to give me
both the "External" and "Internal" ones.
 
Your third chice S/B an asterisk "*" (without the " " !)
Just let your users know that the * = All records
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query Parameter using multiple options 0
Parameter Value error in a Subform 0
Too few parameters error with a IIF statement 5
Modify Parameter Query 1
Access Control on subform / combo box requesting parameter 0
Parameter question for crosstab queries 1
Access Invalid bracketing of parameter name 1
Check Box query issue 3

Back
Top