Search results

  1. $

    List box in query

    I know understand what you mean by having the form open (shows how dumb i am). It was not what i was thinking so each time i tried it, it would not work, i have now just put a button on the form which links to a report which is based on the query, solving my problem. Thank-you for your help
  2. $

    List box in query

    Have checked the spelling of the control source still comming up with the same thing. The form is created off a table of events the form just serving the purpose of entering data into the table therefore the control sorce is the field name, properties confirms this. Do i need to create a new...
  3. $

    List box in query

    Have tried it, came up with a parameter box asking Forms!frmEvents.Event Checked this aganist the field names in the form/table and they were correct Not a list box but if i entered the correct name of an event it did work What am I doing wrong?
  4. $

    List box in query

    Where abouts do I put the is it in the criteria of the heading Event? So Event field from tblEvents with criteria of Forms!FormName.ControlName?
  5. $

    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...
  6. $

    Calculations on Groups

    Thankyou jazi for your suggestion, only probem being i have one field for medal (in which i write Gold, Silver or Bronze, as i could not link one field to 3 in the results table) I did eventually find a solution for anyone who needs it. Field____MedalID____CountryID___Country______MedalID...
  7. $

    Calculations on Groups

    How in the count, can i make it have seperate counts for each country?
  8. $

    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...
  9. $

    Link one field to 3

    I now understand what you mean, thankyou for your help.
  10. $

    Link one field to 3

    Thus far tblResults has... ResultID Gold Silver Bronze Event (From a table of events) Sport (From a table of sports) Venue (From a table of venues) You have medal description, are you saying that in that field there would be the values gold, silver and bronze?
  11. $

    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...
  12. $

    Team Calculation

    Still Not sure sorry but i do not understand exactly what you mean, here is the copy of the database with some fake data in it, is it possible that you would be about to create this table to show me visually thank-you for your help
  13. $

    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