rounding of query output how?

[techexpressinc]

There does not seem to be a simple, obvious way, to round you output of a query:

I am getting numbers like this:
25.3175999112427

And rather have a number like this:
25.32

Sometimes I am doing a sum on a field.
Or if I am just query dumping a field.

I need a simple format process for output of my queries.

Thank you Russ - Rneuman at Scaninc.org

 

[pbaldy]

Have you tried the Round() function?

 

[techexpressinc]

Yes it did not seem to work easily with the sum function:

I put this in the expression:
= ROUND ( [SumOfTIME-SA] , 2)


Then I get prompted for the value SumofTIME-SA


The sum of field TIME-SA is what I want rounded.

Thanks Russ

 

[pbaldy]

Try

Round(Sum([Time-SA]), 2)

 

[techexpressinc]

Paul - I am tried it and got a syntax error.

"Expr1: Round(Sum([Time-SA]),2)" can you please advise a minor change


I did attached a screen print for helping on the resolution.

Thanks
Russ

 

[Atomic Shrimp]

You've just closed too many brackets.

Probably you've typed something like:
Expr1: Round(Sum([Time-SA]),2))

Your screenshot wasn't clear enough to be able to tell exactly where the problem is.

 

[pbaldy]

The screen shot is hard to read, and it doesn't look like the parentheses are correct. Also, you want Expression rather than Group By.

 

[techexpressinc]

Thanks Paul - I will keep adjusting and update the forum as I hopefully get it correct.
Russ