Odd and even

P

PG2015

Registered User.

Local time

Today, 11:13

Joined

Feb 16, 2015

Messages

21

• Jun 20, 2016

• #1

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

Wino Moderator

Staff member

Local time

Today, 03:13

Joined

Aug 30, 2003

Messages

36,269

• Jun 20, 2016

• #2

Check out the Mod operator.

 

P

PG2015

Registered User.

Local time

Today, 11:13

Joined

Feb 16, 2015

Messages

21

• Jun 20, 2016

• #3

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

AWF VIP

Local time

Today, 11:13

Joined

Jul 26, 2013

Messages

10,643

• Jun 20, 2016

• #4

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

 

P

PG2015

Registered User.

Local time

Today, 11:13

Joined

Feb 16, 2015

Messages

21

• Jun 20, 2016

• #5

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

 

jdraw

Super Moderator

Staff member

Local time

Today, 06:13

Joined

Jan 23, 2006

Messages

15,527

• Jun 20, 2016

• #6

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

 

S

sneuberg

AWF VIP

Local time

Today, 03:13

Joined

Oct 17, 2014

Messages

3,506

• Jun 20, 2016

• #7

jdraw said:

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

Click to expand...

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

Super Moderator

Staff member

Local time

Today, 06:13

Joined

Jan 23, 2006

Messages

15,527

• Jun 20, 2016

• #8

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

Code:

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

 

Last edited: Jun 20, 2016

Minty

AWF VIP

Local time

Today, 11:13

Joined

Jul 26, 2013

Messages

10,643

• Jun 20, 2016

• #9

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...

 

S

sneuberg

AWF VIP

Local time

Today, 03:13

Joined

Oct 17, 2014

Messages

3,506

• Jun 20, 2016

• #10

jdraw said:

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

Code:

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

Click to expand...

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

Super Moderator

Staff member

Local time

Today, 06:13

Joined

Jan 23, 2006

Messages

15,527

• Jun 20, 2016

• #11

Yes

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