Filtering by Odd or Even Numbers

[bcash]

I am trying to filter street addresses by odd or even. For example, in a range of addresses, I want to return only the odd number addresses.

I am using {INITCALL.STREET#} in 1500 to 2000 to establish the range but need to know how to refine this range by either odd or even.

Any help would be appreciated.

Sr Det Brian Cash
Intel & Crime Analysis Unit
Leesburg Police Department

[gjack72]

Try adding this to your record selection;
I did this in Vr10 Developer


If(INITCALL.STREET#} In 1500 To 2000
Then Remainder({INITCALL.STREET#},2)>0

If your data type is string you will need to convert your field to number otherwise the above should work.
Hope that helps,
GJ