Search results

I have a query that ranks Finishers by numeric time (NumResult), including ties. Oddly, it pairs ties at the lower of the two places--ie, if two Finishers tie for 2nd, they would both be given a Place of 3. This should be an easy fix, but I can't see what to tweak. Is this too complex a ranking...

I have a query 3_qryMakeFinishMaster that joins a query of all competitive place results (qryJoinFinishers) with a table that assigns a Point value for each Place (tblPlacePoints). The problem is people who didn't finish, who I want to get Points=0. They show up in qryJoinFinishers with a null...

I've done Top 3 queries in a field across records before, but this is a different situation. After a crosstab query, I've got each record consisting of a ClassCode and WholeName and that person's scores for seven meets (for Meet1, Meet2, etc). The problem is summing. I can do a straight sum...

After gradually learning by trial & error on my first Access application--an app for scoring and reporting orienteering competitions--it's gratifying to come across a collection of experts who might help reduce the learning curve. It's been equal parts inspiring and infuriating... :banghead...