Re: format query result

\ is an integer division. If you use \, Access will round both input
numbers and then do a integer division ignoring the remainder.

--
HTH
Van T. Dinh
MVP (Access)



"Akrt48" <Akrt48@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3F2D74A4-9A43-4FF6-A003-3B4043A5C3CE@xxxxxxxxxxxxxxxx
>I have the answer, I just researched this site some more. I have my
>division
> \ the wrong way apparently that is only for integers. Works perfect /
> this
> way!
>


.

Relevant Pages

  • Re: Convert number to Hours and Minutes
    ... Note the backlash \ for integer division which is different from the normal ... HTH ... Van T. Dinh ...
    (microsoft.public.access.queries)
  • Re: Breaking down hours into days
    ... integer division: the \ operator, will give you the integer part of the ... the mod operator will give you the remainder, ... Prev by Date: ...
    (microsoft.public.access.formscoding)
  • Re: converting number of minutes to number of days, hours, minuets
    ... public static void main{ ... You must use integer division and remainder even if you can think of a way to do this without them. ...
    (comp.lang.java.help)
  • Re: modulo operation
    ... >>is a single definition of integer division in mathematics. ... Once the remainder is defined (e.g., as you did, a non-zero remainder is ... The properties of q (whether it is the floor(), truncates toward zero, or ... by -defining- the integer quotient as the ...
    (sci.math)
  • Re: Convert number to Hours and Minutes
    ... and end times and calculating but I would end up with too many fields. ... "Van T. Dinh" wrote: ... > Note the backlash \ for integer division which is different from the normal ...
    (microsoft.public.access.queries)