Format in a Query

  • Thread starter Thread starter Bunky
  • Start date Start date
B

Bunky

Quick (I Hope ) Question. I am supplying data to mgmt over the web. I do
not have web knowledge and have to rely on another person to set up the page.
What I would like to do is have a query produce a result of 76% for seventy
six percent. I am calculating the percent but it always shows .7634323 in
the results of the query rather than the 76%. Ideas??
 
Right click on the percentage field (not the top portion of the query where
the tables go) and change to percentage.
 
I've tried that but it comes back as a decimal. I really have to have the
'%' sign to show.
 
You must log in or register to reply here.

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

Multiple Formats in Calculated Text Box 3
Format function failing in SQL query 1
Multiple Format in Calculated Text Box 1
Date search query 0
Calculating Future Value 6
Help get percentage to show 2
Calculating Subsets of Data 7
Currency Format Lost in Union Query 1

Back
Top