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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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:
Do what I said.  Set the Decimal places property to 2.Specify2DecimalPlaces.JPG
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
PatHartmanCommented:
If this solved your problem, please close the question.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.