Count odd vs even numbers in a record

[lizzie]

Greetings

How does one go about counting the odd vs even numbers in a record. Each record is made up of 6 fields (N1 - N6). How can I calulate the number of odd vs even numbers in each record?

Anyone have a clue?

Thanks a million!

[Raybaudi]

Odd numbers count:

Mod( n1 ; 2 ) + Mod( n2 ; 2 ) + Mod( n3 ; 2 ) + Mod( n4 ; 2 ) + Mod( n5 ; 2 ) + Mod( n6 ; 2 )

[bcooney]

Then, given that there are six fields, the even number count would be the difference ( 6- Odd count). Right?

[Vaughan]

Imagine how much easier this would be if the "numbers" were in separate related records (one record for each number)... :o

[Søren Dyhr]

No Vaughan, this thingy should be squeezed into a known metaphor, be it spreadsheet'ish or wordprocessor'ish!

--sd

[Vaughan]

Hey Søren, I'm trying to be *positive* and *helpful* here!

I'm in a new job (yeah!) and I've just been asked to make a few changes to a database that has been around for many years... and guess what, it uses repeating fields instead of a relational design too. Gee I hate that!

The repeating fields print onto a letter (with sliding/pring set to remove empty repetitions) but the original designer (sic) chose to only show 6/30 repetitions, and the client has 8 things to print!

If you're gonna do the qwrong thing, at least do it right! LOL

[Raybaudi]

...the even number count would be the difference ( 6- Odd count). Right?

Right