Select a range of data from a field

[Anonymous]

Hi Experts,

Simply question for you all 🙂

I am trying to make a"from-till"selection on a database field.
For example: I want all product with [ProductID] from 20000 until 30000.

What I did sofar:

I made 2 variable: vProductID_first and vProductID_Max and made 2 inputboxes to fill in the numbers.
But how do i get vProductID_first to be the first of the range and vProductID_Max to be the last [ProductID].
I have been trying to make a button with a macro function to this but I don't seem to find the right macro code

Or is there an other way maybe?

[Anonymous]

Thanks Rob,

But how do I make a selection in a field where the value is in between 2 variable by using the "select in field"-action?

[rwunderlich]

Use a search expression in the Search String field. There are a couple of syntaxes that work:

='>=$(vStartDate) <=$(vEndDate)'

='>=' & vStartDate & '<=' & vEndDate

If you need quotes around the variable values use:

='>=' & chr(39) & vStartDate & chr(39) & '<=' & chr(39) & vEndDate & chr(39)

-Rob

[gaurav2017]

Hi,

Please look at the attachment, the selection for numerical values in a range is working but the text values are not getting selected. please help in correcting the code.