[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 204
  • Last Modified:

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.
0
p_classic_2000
Asked:
p_classic_2000
  • 3
  • 2
1 Solution
 
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
 
Patrick MatthewsCommented:
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
 
p_classic_2000Author Commented:
Thanks for your help with this!
0
 
Patrick MatthewsCommented:
You're welcome!
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now