Reduce field size in query field

[escapades_access]

I created a new field in a QUERY in order to get an average:

FIELD: Average Root Depth: ([T1-Rooting Depth (RD)]+[T2-RD]+[T3-RD])/3

In datasheet view the number goes out to 13 decimal places.

Any way to reduce it to 2 decimal places as you can in a table?? Thanks!!

[pbaldy]

My first thought is "who cares?", since I never let users view a query directly. In any case, you can wrap your calculation in the Round() function if you want.

[escapades_access]

Thanks pbaldy, but I would like the values to appear manageable- 2 decimal places. I suppose if there isn't a quick fix function I can deal with the 13 decimals...

[pbaldy]

Did you try the Round() function I mentioned?

[escapades_access]

Yes, the rounding worked but isn't precise enough for what I am doing. I would like 2 decimal places rather than a whole number.

[pbaldy]

The Round() function has an argument for how many decimal places to round to.

[escapades_access]

Round(expression, [#decimal places])

So I tried

Average Root Depth: Round((([T1-Rooting Depth (RD)]+[T2-RD]+[T3-RD])/3),[2])

Average Root Depth: Round(Avg([T1-Rooting Depth (RD)]+[T2-RD]+[T3-RD]),[2])

both to no avail. Thanks for the idea. Wish I was having more success!

[pbaldy]

The brackets indicate the argument is optional; you don't want them in your formula. Try

AverageRootDepth: Round((([T1-Rooting Depth (RD)]+[T2-RD]+[T3-RD])/3), 2)

[escapades_access]

Thanks pbaldy, it worked! Seriously, thanks for your help.

[pbaldy]

No problemo! Just noticed you're right over the hill from me. I used to live in Tahoe, moved to Reno for work years ago.