Query even numbers? 1

[Pccoordinator]

Have an access (2000) database I want to query a field (ID) and have the query only pull out the even number records in the ID field.

Can this be done???

 

[JerryDennison]

Yes, add a field to the QBE grid using the following syntax(substitute your actual field names where I have place holders):

Even: [FieldName] Mod 2

Then, in this field's criteria put False. The remainder of any even number when divided by 2 is 0. Since 0 is always False(another way to look at it, is any number that is NOT 0 is True) then setting the criteria to False will give you only those records that are even.

 

[Quehay]

That's a cool solution Jerry!

 

[Pccoordinator]

Thank Your that worked great!

 

[iwanalearn]

It's great. I have a list of 150,000 names and needed to sort every other name into a list. This worked great.
Thanks for the help Jerry!