School Access project

[Steph]

This is my problem I am trying to subtract 15% from
a 'weekly rate column" to get a "discounted weekly rate
column" I click zoom then enter discounted weekly rate:
[weekly rate]-[15%] what am I doing wrong? Remember I am
a student so this is all new to me and the way I put it in
makes total sense to me because that is what I want it to
do.

 

[Rick Brandt]

This is my problem I am trying to subtract 15% from
a 'weekly rate column" to get a "discounted weekly rate
column" I click zoom then enter discounted weekly rate:
[weekly rate]-[15%] what am I doing wrong? Remember I am
a student so this is all new to me and the way I put it in
makes total sense to me because that is what I want it to
do.

How about...
[weekly rate] * 0.85

 

[James]

Try [Weekly Rate] * 0.85 which just takes 85% of weekly
rate or [weekly rate] - [weekly rate] * 0.15 if at some
point the 15% might become variable and this makes it
easier to change.

 

[Roger Carlson]

You don't say if you are using a table or a query. This can only be done in
a query.