Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am doing this query that should have the weekly rate from this table,.
The problem is that I would like to have a new field that has the result of
15% from the weekly rate.
How could I do it?
This is what I did in zoom but I got an error about syntax error.

Discount Weekly Rate[Weekly Rate] - 15%

Please advice
 
I am doing this query that should have the weekly rate from this table,.
The problem is that I would like to have a new field that has the result of
15% from the weekly rate.
How could I do it?
This is what I did in zoom but I got an error about syntax error.

Discount Weekly Rate[Weekly Rate] - 15%

Please advice
Click to expand...

I take it that you wish to show the weekly rate after the 15% has been
taken, not the amount of the discount itself.
100% - 15% = 85%
In other words the rate is 85% of the original rate.

Add a new column to the query grid.
DiscountWeeklyRate:[Weekly Rate] * 0.85

Just for your added information, if you were to wish to see the weekly
rate after a 15% surcharge was added, you would use:

NewWeeklyRate:[Weekly Rate] * 1.15

In other words, the new rate is 115% times the original rate.
 
Back
Top