Is there a way to include text in a parameter query?
I have a query with [Which Issue Type]
I would like to put in the prompt examples of what they need to type in
etc. COF, Design
How do I add text after the parameter?
Advanced Beginner
Windows Vista 
Access 2003
Is there a way to include text in a parameter query?
I have a query with [Which Issue Type]
I would like to put in the prompt examples of what they need to type in
etc. COF, Design
How do I add text after the parameter?
Who is John Galt?
Windows XP Access 2007
Everything in the brackets is your text. You can do:
[Which Issue Type (COF, Design, etc)]
Most of us use forms instead of bracketed parameters, in part because you can validate the user's input. In this case, you could use a combo box that limited them to valid choices.
Too Few Parameters
Too Few Parameters - UPDATE SQL
Posting Permissions
Reply With Quote