G Guest Apr 10, 2005 #1 I have an access database of books. I want to do a query giving a 15 percent discount to the price. Can you tell me how to do this???
I have an access database of books. I want to do a query giving a 15 percent discount to the price. Can you tell me how to do this???
S Scott McDaniel Apr 10, 2005 #2 SELECT [YourPriceField]*0.15 As [DiscountPrice] FROM YourTable would provide you with a 15% discount without altering the current Price.
SELECT [YourPriceField]*0.15 As [DiscountPrice] FROM YourTable would provide you with a 15% discount without altering the current Price.
G Guest Apr 11, 2005 #3 Hi Xeroid. You can create calculated fields in the Query Design View. To do this, click into the "Field" row in the Query Design View, and type the Expression you would like to perform. Example, if you wanted to add the number 2 to a field, you would od this: [field1] + 2 You can also give this calculated field a name, by typing a word followed by a colon, and then your expression, e.g: FieldPlus2: [field1] + 2 Hope this helps, Toby
Hi Xeroid. You can create calculated fields in the Query Design View. To do this, click into the "Field" row in the Query Design View, and type the Expression you would like to perform. Example, if you wanted to add the number 2 to a field, you would od this: [field1] + 2 You can also give this calculated field a name, by typing a word followed by a colon, and then your expression, e.g: FieldPlus2: [field1] + 2 Hope this helps, Toby
