Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    5

    Unanswered: four fastest competitors in each event

    i have a database structures as follows...

    3 tables:

    competitors - the competitors details listed, no field names really important here

    events, the events that are in swimming competiton

    fields:
    event id, for linking tables
    heat, 50m, 100m etc...
    venue, speaks foritself
    location, wher venue is held
    gender, whether its a M or F race
    age group, of the race
    mins, secs, mili secs = 3 different fields holding record.

    results table:
    has competitor id, event id so tables can be linked.
    and has mins secs mili secs to enter the result of the competitor.


    now in the events table there is mins, secs, mili secs free different fields which hold the record, now in results table i have the result that each competitor came in at.

    i need t create a query to list any competitors that have broken the record in each event.

    i have no idea how to do this

    any help appreciated

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713

    Re: four fastest competitors in each event

    Originally posted by forcer
    i have a database structures as follows...

    3 tables:

    competitors - the competitors details listed, no field names really important here

    events, the events that are in swimming competiton

    fields:
    event id, for linking tables
    heat, 50m, 100m etc...
    venue, speaks foritself
    location, wher venue is held
    gender, whether its a M or F race
    age group, of the race
    mins, secs, mili secs = 3 different fields holding record.

    results table:
    has competitor id, event id so tables can be linked.
    and has mins secs mili secs to enter the result of the competitor.


    now in the events table there is mins, secs, mili secs free different fields which hold the record, now in results table i have the result that each competitor came in at.

    i need t create a query to list any competitors that have broken the record in each event.

    i have no idea how to do this

    any help appreciated
    This sounds like a school project ... I've seen this exact problem posted here before ...

  3. #3
    Join Date
    Mar 2004
    Posts
    5

    Post

    yeah it is a project cnt seem to find any previous posts about it tho.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •