Rounding in caculated field (1 Viewer)

cpberg1 · Feb 20, 2015

Let me just start with a :banghead:

I'm trying to get a query to perform a calculation and round the results.

The fields that I am running the calculation and am trying to round are Data Type Number, properties Field size Single and decimal places Auto.

I have tried the built in function described in Allen Browne's site to no avail.
http://allenbrowne.com/round.html

I have tried rounding the individual fields and then adding result.
I have also tried rounding the result (as attached).

Any thoughts?

cpberg1 · Feb 20, 2015

also, will re-name the calculated field "time" to LessonTime. So as to avoid restricted words.

ypma · Feb 21, 2015

The use of the Single data type is not recommended for rounding . Is changing to Double and option you could use ? as you example would then work . I have found that floating point numbers a little tricky to use.

regards Ypma

spikepl · Feb 21, 2015

There is presumably an issue, problem or question here. So what is it?

ypma · Feb 21, 2015

There is presumably an issue, problem or question here.
So what is it?
My understanding is that the issue is that the Rounding function to one decimal point fails to work when using Single number data types, The question is that the Op would like to know why ?

Regards Ypma

spikepl · Feb 21, 2015

Define "failure" - this normally involves some expectation AND some result not matching that expection. There is nothing in the post indicating any software failure or problem. As to the expectations I'd rather not guess so I ask.

ypma · Feb 21, 2015

Define "failure

The post clearly show the use of the function Round with the expectation of a answer to one decimal point, and the result is clearly not what was expected, as shown in the png , so I am at a loss as to why we are not trying help him/her instead of worrying about defining words.

Regards Ypma

JHB · Feb 21, 2015

cpberg1 said:
..
I'm trying to get a query to perform a calculation and round the results.
...

In query design, mark the field/column "Time", ("LessonTime"), and set the property "Format" = "Fixed" and the "Decimal place" = "1"

ypma · Feb 21, 2015

JHB, Not my post but have learned something thank you,

Regards Ypma

cpberg1 · Feb 21, 2015

JHB said:
In query design, mark the field/column "Time", ("LessonTime"), and set the property "Format" = "Fixed" and the "Decimal place" = "1"

JHB, Thank you for the guidance. Worked like a charm, and I learned something also!

cpberg1 · Feb 21, 2015

spikepl said:
Define "failure" - this normally involves some expectation AND some result not matching that expection. There is nothing in the post indicating any software failure or problem. As to the expectations I'd rather not guess so I ask.

Spike, thank you for the reminder to define the failure (expectation and result) clearly.

JHB · Feb 22, 2015

ypma said:
... but have learned something thank you,

Regards Ypma

cpberg1 said:
JHB, Thank you for the guidance. Worked like a charm, and I learned something also!

You're both welcome!

Rounding in caculated field (1 Viewer)

cpberg1

It's always rainy here

Attachments

cpberg1

It's always rainy here

ypma

Registered User.

spikepl

Eledittingent Beliped

ypma

Registered User.

spikepl

Eledittingent Beliped

ypma

Registered User.

JHB

Have been here a while

ypma

Registered User.

cpberg1

It's always rainy here

cpberg1

It's always rainy here

JHB

Have been here a while

Similar threads

Users who are viewing this thread