How to calculate Commission for each ad rep on this query

[armrodnun]

How to calculate Commission for each ad rep on this query? And then how can retrieve only those records where the commission is greater than 50.00 dollars?

I have attached the file to my thread. The query is named: "commissions". Can someone please help me? thanx!

 

[Kryst51]

You have a field called commision which already has values in it., Are you wanting to calculate the "Commission" field times the "rate" field?

If this is so Add a field that says something like this:

Earned: [Commission]*[Rate]

Then in the criteria for that "Earned field" put:

> 50

if it's actually greater than or equal to it would look like:

>= 50