Subtract 3 per cent from field. How do I?

T

TKM

I have a field named interest rate. All of the data is 3% higher than I need
for my report. I need to have a calculation in my query that will lower the
data by 3%.
Such as..

5.65 to 5.35
2.50 to 2.20 etc

My table field is set to number as fixed with 2 decimals and my format is

Initial Rate: [interest rate]*0.947 Problem is I am getting data that looks
like..

4.78, 5.63 etc when it needs to be whole number like 5.65, 2.20 etc. Please
help!
 
K

KARL DEWEY

I need to have a calculation in my query that will lower the data by 3%.
Adjusted by 3%: [YourField]-([YourField]*0.03)

Your numbers below do not reflect a reduction of 3 %.
5.65 to 5.35
2.50 to 2.20 etc
Click to expand...

The percent is lower by 0.3 percent. To do that just subtract 0,3 from the
percentages.
5.65, 2.20 is not 'whole numbers' so I do not know what you are asking.
 
T

TKM

In my expression I am getting numbers like 4.78 when it should be 4.80 and
numbers like 2.33 when it should be 2.35. They need to be rounded up to an
even percentage amount. Does that make sense? Also you stated below..
Adjusted by 3%: [YourField]-([YourField]*0.03) ..Do I put the same field
name in where "YourField" is? Do my properties need to be changed also? They
are set at Fixed and decimals at 2? Thanks so much for your help!

KARL DEWEY said:
Adjusted by 3%: [YourField]-([YourField]*0.03)

Your numbers below do not reflect a reduction of 3 %.
5.65 to 5.35
2.50 to 2.20 etc
Click to expand...

The percent is lower by 0.3 percent. To do that just subtract 0,3 from the
percentages.
5.65, 2.20 is not 'whole numbers' so I do not know what you are asking.
Click to expand...
 
T

TKM

Thanks for your help I just figured it out.

Take care and thanks again

KARL DEWEY said:
Adjusted by 3%: [YourField]-([YourField]*0.03)

Your numbers below do not reflect a reduction of 3 %.
5.65 to 5.35
2.50 to 2.20 etc
Click to expand...

The percent is lower by 0.3 percent. To do that just subtract 0,3 from the
percentages.
5.65, 2.20 is not 'whole numbers' so I do not know what you are asking.
Click to expand...
 
Top