Rounding an "Average"

[Tom]

The rounding expression below does not work. Some values have up to 7
decimals. Does anyone know what's wrong w/ it?


SectionTotal: Avg((Round([RecordAvg],2)))



Thanks,
Tom

 

[Ken Snell [MVP]]

Define "does not work", please. You get no result? It shows an error? It
gives an incorrect result?

 

[Tom]

Ken:

I want to round to 2 decimals. Depending on the values, I get up to 7
decimals.

So, the "rounding" does not work properly.

I'd appreciate if you have additional pointers as to how I can get values
equal to ###.##.

Thanks,
Tom

Define "does not work", please. You get no result? It shows an error? It
gives an incorrect result?

--

Ken Snell
<MS ACCESS MVP>

The rounding expression below does not work. Some values have up to 7
decimals. Does anyone know what's wrong w/ it?


SectionTotal: Avg((Round([RecordAvg],2)))



Thanks,
Tom

 

[Ken Snell [MVP]]

Round again after the Avg function:

SectionTotal: Round(Avg((Round([RecordAvg],2))),2)


--

Ken Snell
<MS ACCESS MVP>

Ken:

I want to round to 2 decimals. Depending on the values, I get up to 7
decimals.

So, the "rounding" does not work properly.

I'd appreciate if you have additional pointers as to how I can get values
equal to ###.##.

Thanks,
Tom

Define "does not work", please. You get no result? It shows an error? It
gives an incorrect result?

--

Ken Snell
<MS ACCESS MVP>

The rounding expression below does not work. Some values have up to 7
decimals. Does anyone know what's wrong w/ it?


SectionTotal: Avg((Round([RecordAvg],2)))



Thanks,
Tom

 

[Tom]

Ken:

Thanks so much... that did the "trick"!

Tom

Round again after the Avg function:

SectionTotal: Round(Avg((Round([RecordAvg],2))),2)


--

Ken Snell
<MS ACCESS MVP>

Ken:

I want to round to 2 decimals. Depending on the values, I get up to 7
decimals.

So, the "rounding" does not work properly.

I'd appreciate if you have additional pointers as to how I can get values
equal to ###.##.

Thanks,
Tom

Define "does not work", please. You get no result? It shows an error? It
gives an incorrect result?

--

Ken Snell
<MS ACCESS MVP>

The rounding expression below does not work. Some values have up to 7
decimals. Does anyone know what's wrong w/ it?


SectionTotal: Avg((Round([RecordAvg],2)))



Thanks,
Tom