Ranking Field

[Coach Ty]

Hello,
I followed all of the steps to create a ranking field with a query and it works perfectly with one exception. Instead of the rankings beginning with the number "1" they begin with the number "0". Can anyone tell me how to make the ranking field begin with 1 and not 0?

Here is the formula I used to create the field, following the steps laid out on the MS Access help site:

OFB Ranking: (Select Count(*) from [OFB Count] Where [MaxOfOFB Score]>[OFB Count2].[MaxOfOFB Score]+1)

Thanks for your help.

 

[John Big Booty]

A simple kludge would be to add one to the result, you've already got.

 

[Coach Ty]

Well, as it turns out simply adding one to the existing formula wasn't the solution afterall. What ended up working was to ad +(-1) to the formula and now it eliminates the "0".
Now I need to find out the best way to eliminate Ties in the ranking column, any ideas?

 

[John Big Booty]

Well, as it turns out simply adding one to the existing formula wasn't the solution afterall. What ended up working was to ad +(-1) to the formula and now it eliminates the "0".
Now I need to find out the best way to eliminate Ties in the ranking column, any ideas?

That's weird how did subtracting one solve the problem