Subtract 3 percent in query field

T

TKM

I have a query (make table) based off a query table that has a field named
"Interest rate". I would like to have 3% taken off all of the figures in that
filed. How do I do this. I have tried in the table and in the query but
nothing seems to work. I did this in Val text box in the table and query
[Interest Rate]-1.03.

What am I doing qrong? Please help
 
T

TKM

OK if I do this where and or in what property do I put the calculation? I
have tried it in the table and in the criteria but the data does not change.
Remember it is a make table query if that makes a difference and it is a
NUMBER field data type. thanks again

Douglas J. Steele said:
To deduct 3%, multiply the field by .97

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


TKM said:
I have a query (make table) based off a query table that has a field named
"Interest rate". I would like to have 3% taken off all of the figures in
that
filed. How do I do this. I have tried in the table and in the query but
nothing seems to work. I did this in Val text box in the table and query
[Interest Rate]-1.03.

What am I doing qrong? Please help
Click to expand...
Click to expand...
 
D

DANIEL BLOOMFIELD

You can create a formula in the field name within the make table query.
This is how I would do it. If your field name is INETERST RATE, add the
field as if that is going to be included in your make table query. Once it
is added, you can modify the field by doing the following:

MODIFIED INTEREST: [INTEREST RATE]*.97

The information before the colon ":" names the field. After the ":" is your
formula. When you create the table, the field should be the calculation of
97% of your original number.




TKM said:
OK if I do this where and or in what property do I put the calculation? I
have tried it in the table and in the criteria but the data does not
change.
Remember it is a make table query if that makes a difference and it is a
NUMBER field data type. thanks again

Douglas J. Steele said:
To deduct 3%, multiply the field by .97

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


TKM said:
I have a query (make table) based off a query table that has a field
named
"Interest rate". I would like to have 3% taken off all of the figures
in
that
filed. How do I do this. I have tried in the table and in the query but
nothing seems to work. I did this in Val text box in the table and
query
[Interest Rate]-1.03.

What am I doing qrong? Please help
Click to expand...
Click to expand...
Click to expand...
 
J

Jeff Boyce

Why? As in "why are you creating a make table query?"

If you do the calculation in the query, do you really need to save that?
Could you simply use the query to see the reduced values?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top