Round up

[HV_L]

Hi,

I have this query in VBA:

SELECT CInt(Count([id])/2+1) AS Aantal
  FROM Wedstrijd
  WHERE (((Year([Datum]))=Year(Now())) AND ((Wedstrijd.Datum)<=Now()));

Now the problem is that in case the outcome of Count([id])/2 is 6,5 Access seems to round this up to 7 +1 makes the final outcome 8

How can I play with rounding upwards and/or downwards ?
How should I write this to get 7 as final outcome ?

Thanks.

 

[rainman89]

The issue is that if you have a .5 it automatically rounds up.. you would have to change this to round down


Question is, is this always going to be the case? Are you always going to want to round down?

 

[HV_L]

Hi Rainman,

Yes, I always want to round down to the whole number, so no decimals.
Can you tell me how this code would look like?
Thanks

 

[rainman89]

check out the int() function and the fix() function instead of cint()

http://www.access-programmers.co.uk/forums/showthread.php?t=125957

 

[Galaxiom]

The Int function returns a result without decimals.

To round up use Int({expression}+0.99)

This will round up 1.01 but not 1.009
Include as many decimal places as you need to control the handling of small decimal values.

However check the result is what you want if using negative numbers as an input.
Int() and Fix() treat negatively numbers differently.

 

[John Big Booty]

Hi Rainman,

Yes, I always want to round down to the whole number, so no decimals.
Can you tell me how this code would look like?
Thanks

In that case take a look at Int() Function in preference to the CInt Function.

Int() returns the integer portion of the number rather than rounding to the nearest integer as CInt() does.

 

[HV_L]

Thanks guys, I'll have a look..