Pulling only Even ID's

jack · Jan 31, 2005

I have a simple Query and want to pull only Even numbered
ID's. How do I put that in my query criteria?

Thanks in advance,

Jack

Dan Artuso · Jan 31, 2005

HI,
Here a sample query:

SELECT tblGroups.id FROM tblGroups
WHERE id mod 2 = 0