How do I use expressions (like "Or") in parameter prompts?

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

Guest

Is it possible to use expressions like "Or", "And" within a criteria prompt
to search on two or more criteria within the same field? I have tried using
speech-marks, brackets etc in a variety if ways in order to distinguish the
expression from the criteria but without success.
 
Ricky said:
Is it possible to use expressions like "Or", "And" within a criteria prompt
to search on two or more criteria within the same field? I have tried using
speech-marks, brackets etc in a variety if ways in order to distinguish the
expression from the criteria but without success.
Click to expand...

You can't have two, or more, parameters separated by OR or AND in a
parameter prompt.
 
You must log in or register to reply here.

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

Use In() Expression as Query criteria with guts from Function 1
query parameter order 4
Using IN expression with a parameter to filter queries 2
Parameter/Criteria settings for percentage expression field 2
Using Prompt with a "like" query parameter 2
Using a period or dot in a parameter query criteria line 2
Parameter Value in Crosstab Query 4
Between Dates Criteria 2

Back
Top