Decimal places for created fields in a query

[cgemmill1]

Good afternoon, I have three quiries with calculated fields in each query. Is there a way to adjsut the decimal places. For example when I calculate a rate here is the result 4.92853622474125E-04. As you can seee this is too long and is in scientific notation.

 

[Galaxiom]

Use the Round function.

 

[ypma]

As Galaxiom pointed out the ROUND function seems your best option .an example for round to 2 places in a query is as follows :-
Speed : Round([distanceTraveled]/[TimeTaken],2)
Hope this is of use to You