Search results

  1. C

    Count number of wins, draws, etc for a team

    No worries been a tad busy with real life things, thanks for the advice all the same. Anyways, considering I'm really only after fundamentally basic statistics on the teams at this time I streamlined the database even more now. I've dropped the stadium and officials tables for now. I have two...
  2. C

    Count number of wins, draws, etc for a team

    "Where's the forest's edge?" asked Cc. "Mmm?" replied the Shark. Just so we're not losing sight my end goal which is to be able to produce a series of reports and add new match stats, for example: Team Overall - overall stats of a specific team, totals, % e.g. home wins, draw %, goals for and...
  3. C

    Count number of wins, draws, etc for a team

    Will look into that thanks. Can I use queries to extract the relevant info for inserting into the appropriate table? e.g. record 1 is Liverpool v Arsenal. Then using query extract the relevant Liverpool stats and insert that into my new FixtureData table, repeat for the Arsenal stats but then...
  4. C

    Count number of wins, draws, etc for a team

    Your explanation on normalisation of data and how it is better to keep two records (one for each team) for each fixture makes sense now. Hopefully, the attached shows a better understanding on my part of this! Next step is to insert the historic data I have into the new tables, currently this...
  5. C

    Count number of wins, draws, etc for a team

    Thank you for the reply, a great help and if I've understood you correctly my new structure as attached is better? Cc
  6. C

    Count number of wins, draws, etc for a team

    I have t_results tables that is as follows: t_results match_id date hometeam (t_teams.teamname lookup) awayteam (t_teams.teamname lookup) winner (t_teams.teamname lookup) I am trying to produce a summary of stats for each team e.g. wins, draws, losses, home wins, home draw, home losses for...
  7. C

    Changing table(s) structure

    Relationship Problem solved, FYI: Exported initial table to Excel, extracted the teams to create a team table and assigned each a unique key. Did a find and replace for each team, replacing the team name with their key. Then imported the tables back into Access and changed the field type on...
  8. C

    Changing table(s) structure

    Hi, I have been provided a table of sport fixtures (and results) that has the following structure: t_fixtures ID HomeTeam AwayTeam Official (various other fixture stats but unique to each fixture) To my understanding of database design it is better if I had three tables, t_fixture, t_teams...
Back
Top Bottom