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
|
|||
|
|||
Posting Calculation to Table
I need to have a form which totals two fields on one table and one field on
another table. There is no relationship to tie the tables, but these totals are used to calculate an amount that is used for billing purposes in an auction database. The first calculation is total of all sales. The second calculation is total penalty for not showing up for auction. These two fields are housed in the same table. The third calculation is total expenses. The calculation is (+total Price - Penalty)/total expenses = commission Commission then needs to be automatically updated in a third table. The problem I am having is the totals are not showing up correctly because the query is trying to associate each price with each expense. Any ideas? |
Thread Tools | |
Display Modes | |
|
|