Novice query

[fullyfactored]

Can someone help me with this query?

I have track results to compare. I have runners and race times from
different meets.

There have been 20 meets. One runner has competed in 15 and a second
runner in seven meets. How can I compare their averages to each other
for the 5 meets they competed against one another. I also want to make
other, similar comparisons. Thank you in advance.

 

[Jeff Boyce]

How to create a query to make that comparison depends on what data you've
stored, and how (i.e., the data structure).

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[fullyfactored]

How to create a query to make that comparison depends on what data you've
stored, and how (i.e., the data structure).

Regards

Jeff Boyce
Microsoft Office/Access MVP








- Show quoted text -

In my Track data database I have a table for Runners with Runner ID,
HomeTown and High School, etc. and another table for Results. The
Results table has ResultsID, RunnerID, Region#, Meet#, Event, and
Time.

Runners(Table) Results(Table)
RunnerID ResultsID
NameFirst Year
NameLast RunnerID#
Hometown Region#
Highschool Meet#
Coach Event#
Time
I hope this helps
Thanks Jeff.

Steve

 

[Jeff Boyce]

It sounds like you are describing a situation where the same two Runners
(RunnerIDs) shows up in more than one Meet (MeetID).

One approach might be to use multiple "chained" queries. One query gets all
the meets each runner is in. Another query joins that first query to a copy
of itself on MeetID. That should give you all Meets any runners have in
common.

Or am I still not seeing your picture?

Regards

Jeff Boyce
Microsoft Office/Access MVP