Does access have a basic modulus function for use in queries?

[Preka]

Just wondering if there is a modulus function available for use in a basic select query in Access. For instance, if I wanted to pull out only my employee IDs that are evenly divisible by 4, would there be a quick way to do that?

 

[PWise]

where ememployeid mod 4 =0

 

[dhookom]

Try

WHERE [employee ID] Mod 4 = 0

Duane
Hook'D on Access
MS Access MVP

 

[MajP]

vb also has integer division
where empID/4 = empID\4