Geachte willema,
Hier onder volgt de query is SQL, ik hoop dat je er iets mee kan, zodat ik de oplossing van mijn probleem ken en dat ik het kan oplossen.
SELECT tblScoreCard.Golfbaan, tblScoreCard.Datum, tblScoreCard.Naam, tblScoreCard.Lidnummer, tblScoreCard.EGA, tblScoreCard.Phcp, tblGolfBanen., tblGolfBanen., tblScoreCard., tblScoreCard., (+2)- AS , tblGolfBanen., tblGolfBanen., tblScoreCard., tblScoreCard., (+2)- AS , tblGolfBanen., tblGolfBanen., tblScoreCard., tblScoreCard., (+2)- AS , tblGolfBanen., tblGolfBanen., tblScoreCard., tblScoreCard., (+2)- AS , tblGolfBanen., tblGolfBanen., tblScoreCard., tblScoreCard., (+2)- AS , tblGolfBanen., tblGolfBanen., tblScoreCard., tblScoreCard., (+2)- AS , tblGolfBanen., tblGolfBanen., tblScoreCard., tblScoreCard., (+2)- AS , tblGolfBanen., tblGolfBanen., tblScoreCard., tblScoreCard., (+2)- AS , tblGolfBanen., tblGolfBanen., tblScoreCard., tblScoreCard., (+2)- AS , ++++++++ AS , ++++++++ AS , ++++++++ AS , ++++++++ AS , tblGolfBanen., tblGolfBanen., tblScoreCard., tblScoreCard., (+2)- AS , tblGolfBanen., tblGolfBanen., tblScoreCard., tblScoreCard., (+2)- AS , tblGolfBanen., tblGolfBanen., tblScoreCard., tblScoreCard., (+2)- AS , tblGolfBanen., tblGolfBanen., tblScoreCard., tblScoreCard., (+2)- AS , tblGolfBanen., tblGolfBanen., tblScoreCard., tblScoreCard., (+2)- AS , tblGolfBanen., tblGolfBanen., tblScoreCard., tblScoreCard., (+2)- AS , tblGolfBanen., tblGolfBanen., tblScoreCard., tblScoreCard., (+2)- AS , tblGolfBanen., tblGolfBanen., tblScoreCard., tblScoreCard., (+2)- AS , tblGolfBanen., tblGolfBanen., tblScoreCard., tblScoreCard., (+2)- AS , ++++++++ AS , ++++++++ AS , ++++++++ AS , ++++++++ AS , + AS PAR, + AS Score, + AS , + AS Stableford
FROM tblGolfBanen INNER JOIN tblScoreCard ON tblGolfBanen.Golfbaan = tblScoreCard.Golfbaan;