Rank If Expression

[mellis]

Hi,

I have created a pretty simple database to calculate sales commissions. One of the areas is on deal volumes.

The BDM will get more commission on his/her 16th deal than their 15th.

As such I need my query to number the each deal. I think this is essentially ranking, but I cant figure out how to get it to work.

I've attached the DB, which may help bring it to life!

Any ideas?

Thanks

 

[mellis]

I have made some progress and have been able to update the DB to rank deals by their date. What I cant get to work is to rank by date for a set individual.


Very frustrating...I'm sure their must be a simple fix...I'm getting a mismatch on type.


Any help would be much appreciated.

 

[JHB]

...I'm getting a mismatch on type.

Because you're trying to add 1 to a string in the field [BDM].

AND [BDM] = [Com1].[BDM][B][COLOR=Red]+1[/COLOR][/B]

 

[mellis]

I knew it would be something stupid.

Thanks for your help, saved me a lot of time trying to suss that one out!