Results 1 to 2 of 2
  1. #1
    Eziox is offline Novice
    Windows 7 32bit Access 2013 32bit
    Join Date
    Feb 2017
    Posts
    1

    Question Query to display match results

    Hello everyone, a newbie here.

    I'm working on a football(soccer) database, and I need a query(or queries) that would display match results in this form: date, team1, results, team 2 example: (24/1/2017, CLUB DE FOOTBALL SECRETARIAT, 4-0, FOOTBALL CLUB DE TETOUAN)

    Tables: it's all in french, where equipe=team, But= Goals, Joueur=Player, Arbitre= referee, faute=freekicks..




    Match:




    Goals:




    Teams:



    your help would be very much appreciated!

  2. #2
    NTC is offline VIP
    Windows 10 Access 2013
    Join Date
    Nov 2009
    Posts
    2,392
    Well let me start out to note that you have a flaw in the design that if a player changes teams you will get bad match scores. Your goals table needs to have the team ID also not just the Player ID.

    What you seek is not able to do in a single query. It is more easily & immediately presented in a report object where you can have the Match as the main report, and then insert sub report with the Goals (with grouping by team)- and thereby present the match & score information.

    In order to distill it down to a single record set's record - you must set up a series of queries: i.e. aggregate & count the goals - and then join this into the match table.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Display records when two OTHER fields match
    By pdowg881 in forum Access
    Replies: 5
    Last Post: 05-21-2015, 02:20 PM
  2. Replies: 3
    Last Post: 05-07-2015, 10:24 AM
  3. Qyery result to display on form
    By keiath in forum Forms
    Replies: 5
    Last Post: 02-15-2014, 06:50 PM
  4. Replies: 4
    Last Post: 12-30-2013, 01:49 PM
  5. Replies: 3
    Last Post: 05-02-2013, 10:36 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums