Consecutive events

D

Don Hintz

I have a racing related database, and I am making some specialized reports.
I want to show consecutive wins by a specific driver at a track. I have a
query that returns all the race winners, but I want to group them in a way to
show that Driver Dale Earnhardt Jr had won 4 consecutive races at Talladega.

I have used a cheat work around where I put a field name in the
tblRaceFinish table called ConsecutiveWins. Then, I manually put the number
in the record. So where he won four in a row, in the four records returned,
each field has a four in it, for the four races in a row at the track he won.
However, lets say in the above example Dale Earnhardt Jr. wins another three
straight at Talladega. I would have to go in and manually change the record
from 4 to 5, then 5 to 6, then 6 to 7.

Not exactly how I want to do it.

I think I'm close, but it just isn't coming to me.

Any ideas?

Thanks,

Don
 
M

Marshall Barton

Don said:
I have a racing related database, and I am making some specialized reports.
I want to show consecutive wins by a specific driver at a track. I have a
query that returns all the race winners, but I want to group them in a way to
show that Driver Dale Earnhardt Jr had won 4 consecutive races at Talladega.

I have used a cheat work around where I put a field name in the
tblRaceFinish table called ConsecutiveWins. Then, I manually put the number
in the record. So where he won four in a row, in the four records returned,
each field has a four in it, for the four races in a row at the track he won.
However, lets say in the above example Dale Earnhardt Jr. wins another three
straight at Talladega. I would have to go in and manually change the record
from 4 to 5, then 5 to 6, then 6 to 7.
Click to expand...


How do you define "consecutive"? Does each race have a
sequence number? If so, is it by the year for all races or
at each race site? For that matter, does a site have more
than one race per year??
 
Top