Hi,

I have problem solving one of the questions in my MS Access tutorial session.

The question requires me to pick all the customers where the Cutomer code is even (it can be divided by 2 without remainder.
I am provided with a list of Customer code.

So how do i set the query in a way that it calls out even number only?

Please please help.
Thank You

Look up the MOD operator
in the Help files:

SELECT ............
WHERE ((CustomerCode] Mod 2=0));