Automatic Counter using DCount

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I have a query that has a Field named Place that puts an auto number in a
row based on where you finish. It is based on another query called
PointsBehind and it sorts according to where you are on the PointsBehind list.
It looks like this
Place: DCount("PointsBack","PointsBehind","PointsBack <=" & [PointsBack])
It works fine. Its just that when scores are tied it goes to the higher
number. For instance If three people are tied fot 2nd it would look like this.
Place Name Points PoinstsBehind
1. Bob 1000 0
4. Jane 980 20
4. sue 980 20
4. Mike 980 20
5. Kevin 970 30
I would like it to go
1.
2.
2.
2.
5.
Any Suggestions

Chris
 
Try using this calculated field:

Place: DCount("PointsBack","PointsBehind","PointsBack <" & [PointsBack])
 
Back
Top