sale + commission query + subform

[londonworker]

sales target table =
allows collection of employee sales figures in order to work out commission. Fields included are target, date, sales achived and commission allocation %. This info will be entered via a query below.

i need to create a query that allows entry of employees sales targets, sales achived, commission % and calculates the amount of commission due.

I will have an employee form where I want a subform to allow entry & calculations of employee commission.

How do I do all this? Please help

 

[lcross]

do it all in a form using vba!
in your subform use fields to do the calculations needed and then the save the fields with the results on your table.