<div>
Hello p_classic_2000,<br />
<br />
Any of that formatting you would set in the display. &nbsp;For example, you can set up a query field<br />
or a form or report control to display any particular number format you want. &nbsp;The data are not<br />
stored that way, though.<br />
<br />
Regards,<br />
<br />
Patrick
</div>


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

<div>
That makes sense. &nbsp;Do you have an example of how I could format this on a form?
</div>


That makes sense.  Do you have an example of how I could format this on a form?

<div>
Thanks for your help with this!
</div>


<div>
<div class="content wysiwyg-content">
I have a query in which an expression divides two numbers to yield a <br />
result I'd like to express as a percentage. &nbsp;<br />
e.g.,<br />
UPDATE tbl2007_conference SET tbl2007_conference.Present<wbr />erRating1_<wbr />perc = PresenterRating1/(NumberAt<wbr />tendees*10<wbr />0);<br />
<br />
Is there a format function or data conversion type I can <br />
apply to the expression such that the datasheet generated by the query <br />
will directly show a percentage value (i.e. 7.5%)? &nbsp;Thanks for any help. 
</div>
</div>


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. 

Format percentage value in a query

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.