Mags CAN ANYONE HELP

[mags]

I want to create a query to show the amount of commission earned from the sale of cars, sales staff all have different percentage levels of commission and there are several makes of cars. have tried a Parameter and a total query cant get it to work

 

[jdraw]

What exactly have you tried? Can you show you sql?

 

[mags]

I need to put in a formula that converts the sales persons percentage of the sale of the car to show what value of commission is generated by each car, if you can understand that