M
mbr96 via AccessMonster.com
I have a table with a MonthlyPmtAmt field (Number data type, Single), that I
notice has varying numbers of decimal places when I export the table to Excel.
The field has a format of "Standard", Decimal Places set to 2. This displays
the data properly when viewed in Access, and I understand that the data is
still stored with however many decimal places it contains. But this is not
gasoline - there are no fractions of cents.
So, I'm trying to round the values to two decimals. I'm testing the Round
function in a select query to see the results before I update them. I'm
using the following expression in the query grid, naming a field
RoundedResult.
RoundedResult: Round([MonthlyPmtAmt],2)
I run the query and I still see the #'s with varying numbers of decimal
places. Whole numbers show with no decimals. If the value has 10 decimals,
they still show. Any ideas?
notice has varying numbers of decimal places when I export the table to Excel.
The field has a format of "Standard", Decimal Places set to 2. This displays
the data properly when viewed in Access, and I understand that the data is
still stored with however many decimal places it contains. But this is not
gasoline - there are no fractions of cents.
So, I'm trying to round the values to two decimals. I'm testing the Round
function in a select query to see the results before I update them. I'm
using the following expression in the query grid, naming a field
RoundedResult.
RoundedResult: Round([MonthlyPmtAmt],2)
I run the query and I still see the #'s with varying numbers of decimal
places. Whole numbers show with no decimals. If the value has 10 decimals,
they still show. Any ideas?