Wuick question: if odd/if even

2002-12-12 Thread Janine Jakim
I Know this is easyIwant a different background depending on the year chosen by the user- basically if it ends as an odd number make background blue if year ends with even number make background green. Is there a better way than saying cif (Right(#Year#, 1) EQ 1) or (Right(#Year#, 1) EQ 3) or

RE: Wuick question: if odd/if even

2002-12-12 Thread Craig Dudley
cfif year mod 2 eq 1ODDcfelseEVEN/cfif -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: 12 December 2002 13:32 To: CF-Talk Subject: Wuick question: if odd/if even I Know this is easyIwant a different background depending on the year chosen by the user

RE: Wuick question: if odd/if even

2002-12-12 Thread Pascal Peters
cfif Year MOD 2 -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: donderdag 12 december 2002 14:32 To: CF-Talk Subject: Wuick question: if odd/if even I Know this is easyIwant a different background depending on the year chosen by the user- basically if it ends

RE: Wuick question: if odd/if even

2002-12-12 Thread webguy
yeap, here u go if (year mod 2) year even else year odd you can use IIF like this too, but the above is easier to read... WG -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: 12 December 2002 13:32 To: CF-Talk Subject: Wuick question: if odd

RE: Wuick question: if odd/if even

2002-12-12 Thread Janine Jakim
Thanks- I knew it was super easy -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 12, 2002 8:38 AM To: CF-Talk Subject: RE: Wuick question: if odd/if even cfif year mod 2 eq 1ODDcfelseEVEN/cfif -Original Message- From: Janine Jakim

RE: Wuick question: if odd/if even-1 more time!

2002-12-12 Thread Janine Jakim
]] Sent: Thursday, December 12, 2002 8:44 AM To: CF-Talk Subject: RE: Wuick question: if odd/if even yeap, here u go if (year mod 2) year even else year odd you can use IIF like this too, but the above is easier to read... WG -Original Message- From: Janine Jakim [mailto

RE: Wuick question: if odd/if even-1 more time!

2002-12-12 Thread Everett, Al
Subject: RE: Wuick question: if odd/if even-1 more time! OOPs My field isn't an integer- it's a string. It isn't just a year 2002/ but set as a school year 2002-2003 2003-2004 So the school year that ends in 2003 I want blue and the school year that ends in 2004 I want in purple

Re: Wuick question: if odd/if even-1 more time!

2002-12-12 Thread Clint Tredway
Try this: if (listlast(year) mod 2) year even else year odd - Original Message - From: Janine Jakim [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, December 12, 2002 12:09 PM Subject: RE: Wuick question: if odd/if even-1 more time! OOPs My field isn't an integer- it's

RE: Wuick question: if odd/if even-1 more time!

2002-12-12 Thread webguy
Maybe, #ListGetAt(year,2,-)# ?? Might need to double check its a number. trim(), Val() etc WG -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: 12 December 2002 18:10 To: CF-Talk Subject: RE: Wuick question: if odd/if even-1 more time! OOPs My field isn't