Jan Of course there are more elegant ways of doing it like Bill suggest
Gunnar Ekblad -----Ursprungligt meddelande----- Från: [email protected] [mailto:[EMAIL PROTECTED] För Bill Downall Skickat: den 18 februari 2008 16:33 Till: RBASE-L Mailing List Ämne: [RBASE-L] - Re: ODD/EVEN Jan, (IFEQ( (MOD(autonumbercolumn,2)), 0, 2, 1)) On Feb 18, 2008 10:25 AM, jan johansen <[EMAIL PROTECTED]> wrote: 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 --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================

