January 22, 200718 yr Newbies What is the simplest way to find serial numbers which are odd or even in a database? I'm not a programmer, so I need a simple method or something I can cut and paste. Thanks!
January 22, 200718 yr You will need to add a calculation field (result is Number) = Mod ( SerialNumber ; 2 ) Then search this field for either 1 (odd) or 0 (even).
January 22, 200718 yr Author Newbies The administrator sent me this: You will need to add a calculation field (result is Number) = Mod ( SerialNumber ; 2 ) Then search this field for either "1" (odd) or "0" (even). It works, but why doesn't it show record number "1"?
January 22, 200718 yr Author Newbies Actually, yes, #1 is selected but it is now the last record in the group.
Create an account or sign in to comment