P
PAR
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?
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?