Help!!!

[shevada123]

I am working on a database and need to create an expression in a query that calculates the following:


For the Adjustment Percentage = Adj %

I need to take the Remaining Tread - 2 and divide by the Original Tread -2 to calculate the Adjustment Percentage. How can I write this expression in the query?

I currently have:

Adj %: [r tread]-2/[o tread]-2

But it seems to give me large percentages i.e. 680%. Percents need to be 0-100% only.

I appreciate the correct expression for this, thanks in advance.

 

[rainman89]

Adj %: ([r tread]-2)/([o tread]-2)