Odd/Even search

[DRankin]

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!

[comment]

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).

[DRankin]

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"?

[DRankin]

Actually, yes, #1 is selected but it is now the last record in the group.

[comment]

I think you need to clarify what you meant by "serial numbers".