Calculation

[woofaloo]

I am creating DB in Access 2013. I haven't worked in Access in several years and the problem I am having is that I need to calculate $ amounts including data from two different tables.

I have created one table for EMPLOYEES and one for INVOICES

The table for EMPLOYEES contains
Rate of Pay
Commission Rate

The table for INVOICES contains:
Days worked (Invoice Table)
Rate (Pulled in from Employees table)
Commission (Pull in from Employees table)
Expenses (Invoice Table)
Total Invoice Amount

Let's say Rate/Day is $100 and the employee worked 6 days. The Commission is 80%.

The way we do this manually now is



Rate * Days Worked - Expenses * commission + Expenses (this gives a total owed to employee)
So, $100 (Rate) * 6 (Days Worked) = $600 - $200 (Expenses) = $400 * 80% (Commission)($320) + $200 (Expenses) = $520

The commission nor the rate will pull from the employee table.

I hope I have not confused you.

HELP!!

Thanks greatly!!

[burrina]

Where are you trying to use this formula, on a form or in a query (or a calculated expression) ?
What is your form setup?

[woofaloo]

Calculated expression.
Please forgive me, but not being well versed in Access, what do you mean by form setup?

[woofaloo]

Sorry didn't read your whole question. I am trying to do this in actually a table to auto calculate the invoice total.

[burrina]

That should be done in either a query or displayed on a form or report.