calculating Percentages

  • Thread starter Thread starter Alesha
  • Start date Start date
A

Alesha

I have a table with a record that is called weekly rate. I need to subtract
the weekly rate by 15% of the normal rate, which I already know the answer
after subtracting the 15%. I just can't figure out how to get the discounted
weekly rate in the query. It is for 3 different units.
unit one is $1,100- 15% is $935
unit two is $1,200- 15% is $1,020
unit three is $1,150- 15% is $977

How to get the answers in the query is what I can't figure out.
 
WHere are you trying to do this? If you add a field in your query something
like:

NewField: [UnitOne] * (1-.15)

what do you get?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
I get an invalid message. I am trying to do this in design View. My IM for
yahoo is ittybitty_84 im me.


Jeff Boyce said:
WHere are you trying to do this? If you add a field in your query something
like:

NewField: [UnitOne] * (1-.15)

what do you get?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Alesha said:
I have a table with a record that is called weekly rate. I need to subtract
the weekly rate by 15% of the normal rate, which I already know the answer
after subtracting the 15%. I just can't figure out how to get the
discounted
weekly rate in the query. It is for 3 different units.
unit one is $1,100- 15% is $935
unit two is $1,200- 15% is $1,020
unit three is $1,150- 15% is $977

How to get the answers in the query is what I can't figure out.
Click to expand...
Click to expand...
 
Alesha

These newsgroups are "staffed" by volunteers, and what gets asked here gets
answered here ... other folks may be able to benefit from the solution you
end up with.

I don't know what you mean by "get an invalid message". If you are getting
an error message, please post the exact message.

Please post the SQL statement (open the query in design view, switch to SQL
view, copy and paste into your reply here) of your query.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Alesha said:
I get an invalid message. I am trying to do this in design View. My IM for
yahoo is ittybitty_84 im me.


Jeff Boyce said:
WHere are you trying to do this? If you add a field in your query
something
like:

NewField: [UnitOne] * (1-.15)

what do you get?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Alesha said:
I have a table with a record that is called weekly rate. I need to
subtract
the weekly rate by 15% of the normal rate, which I already know the
answer
after subtracting the 15%. I just can't figure out how to get the
discounted
weekly rate in the query. It is for 3 different units.
unit one is $1,100- 15% is $935
unit two is $1,200- 15% is $1,020
unit three is $1,150- 15% is $977

How to get the answers in the query is what I can't figure out.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top