Finding Certain Records

[millerlite2ky]

I'm not too sure how to phrase this question, but here goes.
I have a racing database with about 70,000 records, containing the race results: finish, start, car #, driver, etc.
What I'd like to find is a particular driver's current winless streak.
Let's say that Jeff Gordon has run 350 races, but hasn't won a race in (How Many) starts. How can I get Access to find the answer? Eventually, I'd like to also have a form, query, or report show all current drivers' winless streaks, but just trying one thing at a time for right now.

Scott

 

[bat17]

I think that you will need to build 2 queries the first finding the max date of winning races and then use this date to do a count query of races since then

HTH

Peter