ms access

[easg]

Is it possible to create a report in ms access that calculates a porcent based on total, but that at determined value change the porcent? for example all the sales before 200,000 wins 1.5 % of commission, and all the sales after 200,001 wins 2% of commission, all this detailed per invoice, but summin the values of each invoice in a runningsum, and the porcent based in this object.

[doctorgonzo]

Yes, you could calculate varying levels of commission; the quick and dirty way would be to use an IIf as the data source for the text box on the form with something like this: =IIf([sales]>200000, ([sales]-200000)*.02+3000, [sales]*.015)

That would calculate the commission based on a 1.5% rate for the first $200,000 and 2% rate on any sales thereafter.

You can also do a running sum with the Sum() function.

[easg]

I can´t use forms because the data comes from a external odbc database (a m-sdos based database), I need to use the code in the report in order to do this.

[easg]

Sorry I clic before ending the reply.

there could be more than two commission rates.