Formatting Number in Query View

T

Tiz

I'm trying to format calculated fields Charges/Units and Payments/Units to
display 2 decimal places. The Charges/Units allows me to select the
DecimalPlaces in the Properties Box. The Payments/Units field does not show
me the option to select DecimalPlaces. It goes from Format to InputMask.
How do I specify 2 decimal places in that case?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access stripping decimal places in query 1
Using the format function for a percent with four decimal places 5
Add a (sequential not autonumber) number in append query 5
Trouble with large query 0
Changing format on calculated field in a query 2
format a NZ field in a query to 0 decimal places 3
Truncating Numbers 3
how do i get my query to do this 1

Top