Format percentage value in a query

I have a query in which an expression divides two numbers to yield a
result I'd like to express as a percentage.  
e.g.,
UPDATE tbl2007_conference SET tbl2007_conference.PresenterRating1_perc = PresenterRating1/(NumberAttendees*100);

Is there a format function or data conversion type I can
apply to the expression such that the datasheet generated by the query
will directly show a percentage value (i.e. 7.5%)?  Thanks for any help.
p_classic_2000Asked:
Who is Participating?
 
Patrick MatthewsConnect With a Mentor Commented:
p_classic_2000,

Sure.  In the design view, call up the properties for the textbox with that number, and enter
this format string:

0.0%;(0.0%)

Regards,

Patrick
0
 
Patrick MatthewsCommented:
Hello p_classic_2000,

Any of that formatting you would set in the display.  For example, you can set up a query field
or a form or report control to display any particular number format you want.  The data are not
stored that way, though.

Regards,

Patrick
0
 
p_classic_2000Author Commented:
That makes sense.  Do you have an example of how I could format this on a form?
0
 
p_classic_2000Author Commented:
Thanks for your help with this!
0
 
Patrick MatthewsCommented:
You're welcome!
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.