G
Guest
Have a query with a column field that has an expression,
example: PalletNum:[numbers]\4+1. Below in the criteria I
have typed Between[EnterBegin]and[EnterEnd] set as a
parameter for end users to pick the pallet numbers they
want. Did not work, until I entered +0 after [EnterEnd].
Works but only with the number 1 entered as [EnterBegin]
number. If any other number other than 1 is typed for the
[EnterBegin], incorrect data is displayed. If the
criteria using "between" without the parameter is used, it
works correctly. I need a parameter on this field for end
users. Is there some way to set a parameter for this
field that has an expression. Thank you....
example: PalletNum:[numbers]\4+1. Below in the criteria I
have typed Between[EnterBegin]and[EnterEnd] set as a
parameter for end users to pick the pallet numbers they
want. Did not work, until I entered +0 after [EnterEnd].
Works but only with the number 1 entered as [EnterBegin]
number. If any other number other than 1 is typed for the
[EnterBegin], incorrect data is displayed. If the
criteria using "between" without the parameter is used, it
works correctly. I need a parameter on this field for end
users. Is there some way to set a parameter for this
field that has an expression. Thank you....