Creating a Calculation in a Query

[KimHuff]

I am trying to create a calculation in my query that will give me the percentage we are discounting a product from the MSRP.

For example, I have two fields

RetailPrice - set as Currency
MSRP - set as Currency

I created a query and typed in the following expression.

Discount: ([MSRP]-[RetailPrice])/([MSRP])

Although it is giving me the correct calculation, it isnt displaying it in the format I wanted.

For example,

MSRP - Retail Price / MSRP = Discount Percentage
27.00 - 21.95 / 27.00 = 0.187037037037037

Ideally, I would like for it to merely display as 19%. Is this possible? If so, how would one go about making that happen?

Thank you in advance,

Kim

 

[khawar]

Right click the field in the design view of query go to properties and set the format to currency of the calculated field

 

[KimHuff]

Thank you for taking the time to respond to my question. I knew it was an easy fix I just couldnt figure it out.

Thanks a bunch!

Kim