Re: Removing Decimal Places in Query



Oops
CInt(1.6666) = 2

Int(1.6666) = 1

--
Duane Hookom
MS Access MVP


"Chris2" <rainofsteel.NOTVALID@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:Gtmdnd4DaIbQEv7eRVn-sg@xxxxxxxxxxxxxx
>
> "Tom" <tanorris@xxxxxxxxxxxxx> wrote in message
> news:99u6m1h9qv7fjke3vg7d6scvc0o20nue2j@xxxxxxxxxx
>> I am using some calculated summary queries that involve
> multplication.
>> The results of these queries are accurate but are yielding up to
> four
>> decimal places, e.g., 16.6666. I do not want any decimal places,
> only
>> whole numbers, e.g., 16. I adjusted the Report Properties to 0 but
>> still get the decimals in the Report Textbox and on the subsequent
>> Chart. How do I get rid of decimals in a query?
>>
>> TIA
>>
>> Tom
>
> Tom,
>
> CInt() will get rid of fractions.
>
> ---------------
> CInt(<expression>)
>
> Examples:
>
> CInt(1.6666)
>
> 1
>
>
> CInt(2.356)
>
> 2
> ---------------
>
>
> Sincerely,
>
> Chris O.
>
>


.