converting numbers to percentage

[jadeIT]

This seems like an easy question, but i have no idea how to do it...

If I have a field for the [costprice] and [soldprice], I can work out the profit by calculating [soldprice]-[costprice].

So, if costprice=60, soldprice=120... profit=60.

In this case the profit margin was 100% of the costprice.

How can I make an access query that tells the profit as a percentage???

 

[glynch]

Enter this into another field in your query:

PercentProfit: ((SoldPrice - CostPrice)/CostPrice) * 100

 

[antomack]

Use the following expression in the query

([soldprice]-[costprice])/[costprice]

Then right click on that column and select properties. Then set the Format to Percent. The field will now display as a percentage.

 

[jadeIT]

Ahh.. Yeah thanks.. my mind is blank today.. I knew it would be simple..