Re: Removing NEAR duplicate results

Hi -

Your example doesn't show age. How are you computing it? If based on the
year ran, that could be a problem, i.e. today is 30 Sep, the runner's age
will differ by one year based on whether their birth date (mm/dd) is less
than or >= today's date (mm/dd). Think this would need to be resolved before
going on with further calculations.

Bob



sharpie23@xxxxxxx wrote:
I have a database of runners times on each course. I also have the
year they ran that time and their age that year. I am trying to make a
top 10 list for each age and a top 10 list for all runners on a
particular course.
The problem I am running into is that a runner may have had multiple
times on a certain course that are on the top 10 list. I only want
that particular runners' top time

For intance a top 10 result now may read

Matt 2006 16:56
Joe 2007 7:00
Matt 2005 17:11
Matt 2006 17:16
Matt 2007 17:24
Joe 2005 17:25
Fred 2006 17:34

etc...

I want it ot just return
Matt 2006 16:56
Joe 2007 17:00
Fred 2006 17:34

and then fill in the rest of the top 10

Obviously the only portion that is a duplicate is the name and course.
The year may or may not be different. The times will be different. The
age may or may not be different.

any ideas?

-Ryan Sharp

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200709/1

.

Relevant Pages

  • Removing NEAR duplicate results
    ... I have a database of runners times on each course. ... year they ran that time and their age that year. ... Matt 2006 16:56 ... Joe 2007 7:00 ...
    (microsoft.public.access.queries)
  • Re: Another Brain Dead Bimbo Joins The Cast.
    ... Will the companion be in awe of the doctor, ... our relationship to knowledge and wisdom. ... What age do real doctors qualify to start practicing? ... Isn't that about the same age that Matt Smith is now? ...
    (rec.arts.drwho)
  • Re: Removing NEAR duplicate results
    ... Your example doesn't show age. ... that particular runners' top time ... Joe 2007 7:00 ... Matt 2005 17:11 ...
    (microsoft.public.access.queries)
  • Re: Tuf luck
    ... but Matt Hughes's guys, lost another preliminary fight... ... Matt had to comfort him. ... At an early age you were taught, ... man was supposed to act and he taught his sons his expectations. ...
    (rec.martial-arts)
  • Re: Who knew?
    ... Matt wrote: ... conversational context, but I don't remember when I started hearing ... Kobe lived in Italy from age six to age thirteen. ... As if those privy to the deadly secret ...
    (alt.usage.english)