Minimizing number length in queries

[Madchemist]

I have a table with temperature readings over a 12 hour time period. I have to find the average temperature over that time period. I built a query for a specific time period that listed all of the temperatures. I then queried that query to get the average temperature. It works great but there are at least 10 numbers to the right of the decimal place that I don't need. I can't figure out how to minimize the quantity of numbers that are displayed. I tried adjusting the size in the original table but have had no luck. Any suggestions?

[Robeen]

You can try this:

 
Dim YourNumberBefore, YourNumberAfter as Double
YourNumber = 96.12398473283
 
YourNumberAfter = Format (YourNumberBefore, "#,##0.00") 'Should return '96.12'

[Robeen]

Sorry, you need that to run in your query.

In query design, add your Temperature field and then do this where the field is added:

FormattedTemp: Format([Temperature], "#,##0.00")

I think that will give you your two [if that's what you need] decimal places.

OR - again in query design mode, click in your Temperature field, open the Properties for that field, select the type of data that you need the Temperature field to be - and then change the Decimal Places value to whatever you need it to be.

I hope this helps!