A
aceavl via AccessMonster.com
hi! hope you can help me AGAIN!
i have a form that let's the user pick a name, job, between dates, tax(with
or without) and percentage. this is for calculating the comision each
employee has earned.
i did this by a query that gets the info from the form adn then opens a
report and in the report i make the calculations.
but it turns out that several employees have 2 or more "jobs" and for each
one diferent % of comission.
the form and the reports handdle it fine, i'm looking for a way to add all of
this reports for each person.
i was thinking of saving the sum of each query in a variable on the form and
then calculate the % and sum them to get the grand total and display it in a
report.
how can i save the sum of query in a variable?
or how do i add 2 or 3 reports?
any pointers would be apreciated!
thanks
i have a form that let's the user pick a name, job, between dates, tax(with
or without) and percentage. this is for calculating the comision each
employee has earned.
i did this by a query that gets the info from the form adn then opens a
report and in the report i make the calculations.
but it turns out that several employees have 2 or more "jobs" and for each
one diferent % of comission.
the form and the reports handdle it fine, i'm looking for a way to add all of
this reports for each person.
i was thinking of saving the sum of each query in a variable on the form and
then calculate the % and sum them to get the grand total and display it in a
report.
how can i save the sum of query in a variable?
or how do i add 2 or 3 reports?
any pointers would be apreciated!
thanks