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

R

Ricky Rock

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.
 
M

MGFoster

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.
 
Top