I have a problem with my reports in that, if I select all the distinct values of a column in my table as values in my record selection formula I get different results to if I select no values and also different to using the between function.

 

i.e.

1. {view.Codes} in ['1','2','3','4','5']

2. ToNumber({view.Codes}) in ToNumber('1') to ToNumber('5')

3. no selection formula for {view.Codes}.

 

1 to 5 is just an example, but all these methods produce different results.

 

Can anyone tell me why and maybe help me to resolve this error.

 

Thanks,