Add a calculated field named Discount %, where Discount % displays the percentage qualifying customers will have deducted from their bill when they check out. If customers have an AAA discount, display the text 10% off. If customers have an AARP discount, 15% off. If customers have a Military discount, 20% off. Additionally, if customers are staying more than three days and do not have an AAA, AARP, or Military discount, display 5% off. If they do not receive a discount, then display No Discount in the field. Ensure that the conditions are set in that order. Run the query, and then save it as qty discounts. Close your query.