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.

Remove the brackets from around the 15%.

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

[WeeklyRental]*.85