Calculate Profit margin and place in table as %

[cookitup]

I am trying to use the code below to determine profit margin, However, I want the sum to show as a percent in the table and Form. Please Help!

Me.Margin = (Me.Quote_Amount - Me.Cost) / Me.Cost / 100

This is returning a "0" in the field

 

[pbaldy]

What is the data type/length of Margin in the table?

 

[cookitup]

Number/Long Integer

 

[GregRun]

Along those lines:

Make the "Field Size" for your field "Double", change the "Format" for the field in your table and form to "Percent", then change the "Decimal Places" in the table and form to your desired number of decimal places.

 

[cookitup]

Greg, That worked perfectly, However, it is readin 0.25%...is there a way I could have it read just 25%???

 

[cookitup]

Never mind Greg, I figured out my problem.!!! thanks again

 

[GregRun]

Yes, don't divide by 100!