Need help witha calculation query

[moschino_123]

hi im new to this and really need someones help basically i have
created a database with a number of tables such as: Member id, Sales
Table and rental table.
in my sales table i sell dvds and i need help with a calculation, i
have the original price of a dvd aswell as a percentage reduction with
a drop down menu with differnet percentages and a new price field. i
would like help to calculate this, for example a dvd is £9.00 and has
a percentage reduction of 5% i would like the query to calculate the
new price.

Please someone help

 

[Guest]

In a new column in the query, name your new formula field and put a : after
it. Then type in [price field name]*(1-[discount field name])