Re: Removing Decimal Places in Query
- From: "Duane Hookom" <duanehookom@xxxxxxxxxxxxxxxxxx>
- Date: Sat, 29 Oct 2005 14:55:08 -0500
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.
>
>
.
- References:
- Removing Decimal Places in Query
- From: Tom
- Removing Decimal Places in Query
- Prev by Date: ORDER BY a Calculated field
- Next by Date: Copy a date from a cel to another depending on another cel.
- Previous by thread: Removing Decimal Places in Query
- Next by thread: Conditional Formatting
- Index(es):
Relevant Pages
|
|
