[AccessD] This is weird - what's the cause?

Kathryn,

It might not the answer to why its not populated but its the cause: #69 is
missing because of of a nonmatch in the join for LINK. Look at row 16747 in
tblRunnerTimes, which is missing an entry in RT-IDCP. It's the only one like
that in the table, and when its populated 69 appears in qryProgressReport.

Jim

----- Original Message ----- 
From: "Kathryn Bassett" <kathryn at bassett.net>
To: "dbAdvisors (AccessD)" <accessd at databaseadvisors.com>
Sent: Tuesday, September 30, 2003 10:33 PM
Subject: [AccessD] This is weird - what's the cause?


> 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?
>
> --
> Kathryn Rhinehart Bassett (Pasadena CA)
> "Genealogy is my bag" "GH is my soap"
> kathryn at bassett.net
> http://bassett.net
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com