Stuart McLachlan
stuart at lexacorp.com.pg
Wed Oct 1 00:31:10 CDT 2003
On 30 Sep 2003 at 20:33, Kathryn Bassett wrote: > The A2K race database is zipped and available at: > http://ac100.com/finish/2003Ac100.zip > It's been brought to my attention that runner with bib #69 doesn't show up on either Most Current Times (Bib Order) or on Most Current Times (Who's Ahead). Both of those use qryProgressReport which is based on calculations from some of the others. > > qryRunnerTimes1A and qryRunnerTimes2 and qryRunnerTimes2A and qryRunnerTimes3 all show runner with bib 69, but qryProgressReport dumps that bib number. I never noticed it myself, but someone tracking the runner called it to my attention when asking why he wasn't on website. > > So, what causes him to get dumped from the list? > Record 16747 in tblRunnersTimes has no RT-IDCP. That is the linking record for Runner 69 through qryRunner2A. You have an inner join on RT-IDCP and tblCheckpoint in qryProgressReport. -- Lexacorp Ltd http://www.lexacorp.com.pg Information Technology Consultancy, Software Development,System Support.