calculations within a query (1 Viewer)

[opusx001]

I have a weekly rental rate for property owners. How do I display a field "discounted weekly rental" to show a 15% discount on the weekly rate if rented for more than 1 week at a time? I tried Discounted Weekly Rental: [weekly rental]-[15%]. When I run the query it asks me to enter a parameter value.

 

[vangogh228]

Remove the brackets from around the 15%.

 

[opusx001]

I removed the brackets around [15%] and when I exit to save I get an invalid syntax message with the % sign selected.

 

[Rich]

[WeeklyRental]*.85