Rounding Decimals in Table Field

[wcrimi]

I have a query that does some calculations and stores the results in a table field defined as Fixed with 2 decimal positions.

When I display the table field it shows 2 decimal positions, but if I look at how the data is actually stored or export it to Excel it's stored with as many decimal positions as were in the result.

So if the result was 99.1191111 it shows me 99.12, but if I export it it exports 99.1191111 to Excel.

Is there any way to change the data in that table to actually store it as 2 decimal positions rounded?

[Minty]

The decimal places is actually only really a display format, not how the number is stored.

If you adjust your queries to round the answer to only two decimal places that will fix the problem.

More info here https://www.uvm.edu/~bnelson/compute...malplaces.html

[Micron]

Hmm, the general opinion is that you don't store calculations, except maybe in rare cases. I wonder if this is one of those cases.

[wcrimi]

Hmm, the general opinion is that you don't store calculations, except maybe in rare cases. I wonder if this is one of those cases.

That's probably good advice in general, but in this case I needed it stored in the table. I found a way around it in Excel which is where the data ended up in this case anyway. So I'm good to go!

Thanks

[Micron]

in this case I needed it stored in the table.

That is seldom really true, but you might have an exception. The thinking is that forms and reports should do calculations on the fly in case any inputs change. In case you want to follow up on the theory
http://allenbrowne.com/casu-14.html