Odd and even (1 Viewer)

[PG2015]

Hi scratching my head to get an IIF for odds or even in numbers. Ie if its an even number state "EVEN" in column. Obviously if odd state "ODD".

Any ideas please.

Thanks

PG

 

[pbaldy]

Check out the Mod operator.

 

[PG2015]

Thanks - afraid I am a bit of a numpty with access and cannot see how to construct MOD in a query string. Any example would be a great help.

 

[Minty]

IIf (YourField Mod 2 ,"Odd", "Even" )

 

[PG2015]

That's got it! Thanks very much for your help.

 

[jdraw]

I would think
.evenly divisible by 2..if true,..if false
IIf (YourField Mod 2 , "Even","Odd" )

 

[sneuberg]

I would think
.evenly divisible by 2..if true,..if false
IIf (YourField Mod 2 , "Even","Odd" )

Yeah if it were

IIf (YourField Mod 2 = 0 , "Even","Odd" )

Which I think is better since YourField Mod 2 by itself isn't really a boolean expression and just relies on the fact that any non zero values is considered true.

 

[jdraw]

Agreed. My issue was with the placement of Odd/Even (should be reversed)
in Minty's post.

IIf (YourField Mod 2 ,"Odd", "Even" )

 

[Minty]

I actually borrowed it from an excel forum and it seemed to be correct, but as you say it doesn't account for non 0 null values. It's too hot and Monday, that's my excuse...

 

[sneuberg]

Agreed. My issue was with the placement of Odd/Even
in Minty's post.

IIf (YourField Mod 2 ,"Odd", "Even" )

But that placement is correct with the condition being YourField Mod 2 which is true when the YourNumber is odd. YourField Mod 2 = 0 is true when YourNumber is even.

 

[jdraw]

Yes

IIf (YourField Mod 2 = 0 , "Even","Odd" )