Jan: Try the following definition for your computed column:
IFLT( ((INT(your_AutoNumber_column/2)) *2), your_AutoNumber_column,1,2) It should calculate all odd numbers as 1 and all the even numbers as 2. By the way, 0 (zero) will be calculated as 2. If you want the results to be text, just add quotes to the 1 and 2 at the end of the expression. Javier, Javier Valencia, PE Sr. Project Manager Universal Asset Management, L.L.C. 801 Westchester Ave. Harrisonville, MO 64701 Phone: 816-887-4011 Fax: 816-887-1960 Cell: 913-915-3137 -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of jan johansen Sent: Monday, February 18, 2008 9:26 AM To: RBASE-L Mailing List Subject: [RBASE-L] - ODD/EVEN I am struggling with a computed column. I have a table with an autonumber. The goal is to have odd number rows = 1 and even number rows =2 but I'm not quite getting there. Jan
