Question about fitering

M

Megan

In my Clients table I have an autonumber field for Client ID. My boss would
like me to pull 2 seperate reports: 1 with all the odd Client ID numbers
(autonumber) and 1 with all the even Client ID numbers. I have messed around
with filtering and queries and I cannot figure out how to do this.

Is it possible?
 
O

Ofer Cohen

For Odd numbers

SELECT TableName.*
FROM TableName
WHERE [Client ID] Mod 2=1

For Even numbers

SELECT TableName.*
FROM TableName
WHERE [Client ID] Mod 2=0
 
Top