Removing Decimal Places in Query

[Tom]

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

 

[Chris2]

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.

 

[Duane Hookom]

Oops
CInt(1.6666) = 2

Int(1.6666) = 1

 

[Chris2]

Oops
CInt(1.6666) = 2

Int(1.6666) = 1

<Looks back at his still open Immediate window, the last action
peformed in it having been the above CInt.>

Yup, 2.

I also typoed the second CInt function, although there is also an Int
function.



Sincerely,

Chris O.