G
Guest
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!
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!