If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Need help witha calculation query
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 |
#2
|
|||
|
|||
Need help witha calculation query
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]) " wrote: 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 |
Thread Tools | |
Display Modes | |
|
|