Format in a Query

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??
 
G

Golfinray

Right click on the percentage field (not the top portion of the query where
the tables go) and change to percentage.
 
B

Bunky

I've tried that but it comes back as a decimal. I really have to have the
'%' sign to show.
 
Top