Morning everyone,

I have (hopefully) a quick query regarding using the Round() Function in a
query

I need to be able to round any value up to the nearest whole number , where
as the standard round funtion round up or down dependent on the closest whole
number.

So can you force it round up always?

Kindest Regards

Jai

Thanks for the reply

However the Int() Function rounds down the number

example value 2.06 should be 3 but it returns 2

Jai

"Van T. Dinh" wrote:

> Use the Expression:
>
> - Int(-YourNumber) to round it up to the higher whole number.
>
> --
> HTH
> Van T. Dinh
> MVP (Access)
>
>
> "Jai_Friday" wrote:
>
> > Morning everyone,
> >
> > I have (hopefully) a quick query regarding using the Round() Function in a
> > query
> >
> > I need to be able to round any value up to the nearest whole number , where
> > as the standard round funtion round up or down dependent on the closest whole
> > number.
> >
> > So can you force it round up always?
> >
> > Kindest Regards
> >
> > Jai

Did you use the 2 negative signs as I posted???

--
HTH
Van T. Dinh
MVP (Access)



"Jai_Friday" <(E-Mail Removed)> wrote in message
news:16CABA38-DAC3-4C3A-B890-(E-Mail Removed)...
> Thanks for the reply
>
> However the Int() Function rounds down the number
>
> example value 2.06 should be 3 but it returns 2
>
> Jai
>

Hi Jai,

Add 1 to result of Int()

Regards


"Jai_Friday" <(E-Mail Removed)> wrote in message
news:16CABA38-DAC3-4C3A-B890-(E-Mail Removed)...
> Thanks for the reply
>
> However the Int() Function rounds down the number
>
> example value 2.06 should be 3 but it returns 2
>
> Jai
>
> "Van T. Dinh" wrote:
>
>> Use the Expression:
>>
>> - Int(-YourNumber) to round it up to the higher whole number.
>>
>> --
>> HTH
>> Van T. Dinh
>> MVP (Access)
>>
>>
>> "Jai_Friday" wrote:
>>
>> > Morning everyone,
>> >
>> > I have (hopefully) a quick query regarding using the Round() Function
>> > in a
>> > query
>> >
>> > I need to be able to round any value up to the nearest whole number ,
>> > where
>> > as the standard round funtion round up or down dependent on the closest
>> > whole
>> > number.
>> >
>> > So can you force it round up always?
>> >
>> > Kindest Regards
>> >
>> > Jai

That sorted it , those 2 negatives god blee em

Thanks once again

"Van T. Dinh" wrote:

> Use the Expression:
>
> - Int(-YourNumber) to round it up to the higher whole number.
>
> --
> HTH
> Van T. Dinh
> MVP (Access)
>
>
> "Jai_Friday" wrote:
>
> > Morning everyone,
> >
> > I have (hopefully) a quick query regarding using the Round() Function in a
> > query
> >
> > I need to be able to round any value up to the nearest whole number , where
> > as the standard round funtion round up or down dependent on the closest whole
> > number.
> >
> > So can you force it round up always?
> >
> > Kindest Regards
> >
> > Jai

I think you would get an incorrect result if the input is a whole number.

--
HTH
Van T. Dinh
MVP (Access)


"Terry" wrote:

> Hi Jai,
>
> Add 1 to result of Int()
>
> Regards
>