Need to right align a query calculation field: ReadBooks: Format([Books]/[Readers], "#,###.00")

Need to right align a query calculation field:

ReadBooks: Format([Books]/[Readers], "#,###.00")

Cannot get output to right align.  Can use Round function but it does not always give me 2 decimals.
deer777Asked:
Who is Participating?
 
PatHartmanConnect With a Mentor Commented:
Do what I said.  Set the Decimal places property to 2.Specify2DecimalPlaces.JPG
1
 
PatHartmanCommented:
Text fields are always left aligned.  Numeric fields are always right aligned.  Format, turns this numeric field into a text field.  That makes this field always left aligned.  How data is stored is of no importance.   To control how it is displayed, leave it as numeric (do not use the Format() function) and change the number of decimal places to 2.  If the division results in 5 decimal places, Access will store 5 decimal places but will only display 2 of them.

We need to know what problem this is causing to determine how to proceed from here.
0
 
deer777Author Commented:
If I just run the calculation only without the format function along with the "Standard" format, my output sometimes extends my decimal points beyond 10.  I only need 2 decimal points.  I tried using the Round function but it does not give me 2 decimals on each calculation.  In some instances, it gives me 0 decimals but I need 2 decimals every time, not 3, not 0 but only 2.  

I am dividing two numbers which gives me decimals (I want it to show 2 decimals for each output).    

Please tell me how I can change the number of decimal places to 2 decimals in every output within the query?
0
 
PatHartmanCommented:
If this solved your problem, please close the question.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.