Parameter querie, is this possible ?

[Guest]

Hello,

currently the parameter is looking like this [Input department code:]. Input
will be like "300" and It will then return the data belonging to this
department.

My question:

Can I write so that I get between departments. By using something similar to
this:

"300..306" in the same input window and still get answares listing all the
departments between those 2 input values ?

Perag

 

[David F Cox]

something like:

BETWEEN [enter dept 1] AND [enter dept 2]

 

[Guest]

Sweet, thanks alot that worked!

Perag

something like:

BETWEEN [enter dept 1] AND [enter dept 2]

Hello,

currently the parameter is looking like this [Input department code:].
Input
will be like "300" and It will then return the data belonging to this
department.

My question:

Can I write so that I get between departments. By using something similar
to
this:

"300..306" in the same input window and still get answares listing all the
departments between those 2 input values ?

Perag