Need to group Odd and Even numbers

[ckyle]

Hello,

I am new to Access and I need some help.

I need to group address numbers into odd and even groups. I have trie
to use the isodd/iseven functions, but am unable to get it to work.
am not sure if it needs to go into the criteria of my address number
or of the proper syntax.

Thanks for any info, ck

 

[John Vinson]

Hello,

I am new to Access and I need some help.

I need to group address numbers into odd and even groups. I have tried
to use the isodd/iseven functions, but am unable to get it to work. I
am not sure if it needs to go into the criteria of my address number,
or of the proper syntax.

Well, the proper syntax depends on the datatype and contents of the
address field.

Assuming that it's a Text field with data like "123 E. Elm St." you
can use the following expression:

OddEven: Val([Address]) MOD 2

This field will be 0 for even, 1 for odd street numbers.

The IsOdd and IsEven functions, I believe, are Excel functions.
Frustratingly, the Access help offers help on functions that aren't
readily available in Access without clearly indicating that they
aren't!