Division Remainder

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

Is there a function to calculate the remainder of a
division?


e.g., 17 / 4 = 4 remainder 1

I want to use the 1.
 
Mark,

Modulo function is built in Access. The syntax is
17 Mod 4
as per your example. Can be used in calculated fields in queries, calculated
controls on forms and in reports, in code, anywhere.

HTH,
Nikos
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Doing a Divide Need The Whole Part Only... 4
DATEPART FUNCTION 1
Surprisingly fidly query? 2
Giveaway The Division FREE 2
excel formula 1
IIF Statement 2
remainder in a division 2
Find Replace values when they are not null 3

Back
Top