Search results

  1. $

    List box in query

    I have created a database showing the results for a number of events with long and complicated names. In the database is a query which select the first, second and third for each event, I would like to have it show each event seperately unfortunatly the number of events is to large to create a...
  2. $

    Calculations on Groups

    tblCountries -- CountryID, Country tblAthletes -- AthletesID, FirstName, Surname, CountryID, M/F tblSports -- SportID, Sport tblEvents -- EventID, Event, VenueID, SportID tblVenues -- VenueID, Venue, Location tblMedals -- MedalID, MedalType tblResults -- ResultID, AthleteID, MedalID, EventID...
  3. $

    Link one field to 3

    I have a database which works as an information system for the upcomming olympics. In tblAthletes is... AthleteID (Primary Key) FirstName Surname And Various other fields not needed in this problem In tblResults is... Gold Silver Bronze Also other field in this table What I am aiming for...
  4. $

    Team Calculation

    I have created a relational database for my local running club. It has 2 tables, 1.information on athletes which includes name, athlete's club etc as well as an individual athlete number which is the primary key. and 2. A positioning sheet with the place as an autonumber (This is an autonumber...
Top Bottom