Modulo in Access

[ckirmser]

Hello, group!

Does anyone have a painless way to do modulos in a query? Either in the Expression Builder or the criteria, either will work for me.

Thanx!

 

[chergh]

It's probably easiest to do in sql view

SELECT [field_name] mod [2nd field or number] As Mod_Result
From Table_name

The [field_name] is the number to be divided, [2nd field or number] is the divisor. When you run the query the modulus will be given in the recorset.

 

[ckirmser]

Thanx, chergh!

I'll give that a try.