STR(ROUND(AVG([Testnumber]),2)) + ': Test Append'
Check out this post: ROUND function returns strange results
On the second page Bora Beran linked here, common issue with database type rounding and strings.
You get around it by averaging it first. Can be the max, min, etc. Just need some aggregation.
thanks! that worked! And thank you for the reference, I will put that in my memory bank somewhere...