access problem

X

xeroid

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

SELECT [YourPriceField]*0.15 As [DiscountPrice] FROM YourTable

would provide you with a 15% discount without altering the current Price.
 
T

th0r0n

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
 
Top