Dollars To Percent

[Guest]

Hello all. I have a question with conversion of dollar values to
percentages. I have a form with three fields stack one atop another. The
first field is the total dollar amount field. The second field is the dollar
value spent at Company A. Field three holds the value spent at Company B. I
want two more fields below these three. The first of these two new fields
would hold the percentage spent with company A, and the second of these
fields would display the percentage spent with Company B. I am just not sure
how to convert the dollar values to percentages. Is there an expression that
I can put in the data field of an unbound text box? Thanks.

 

[Arvin Meyer]

In a query, add alias columns:

Expr1: Format([CompanyA]/[TotalField], "Percent")
Expr2: Format([CompanyB]/[TotalField], "Percent")

Base your form on the query instead of the table.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access