In a query in design view,
Display only the products eligible for a discount (Discount field is yes/no) but not the discount field itself.
Field in query are ProductID, ProductType, and Price
Display in a calculated field 5% discount of the price
I know how to add fields but need help with...