How can I display all the data in the rdlc report matrix?

See more:

VB

SQL

Hello, I am writing to ask for help from the community because I know that here I will certainly find the solution to my problem. I have been looking for several days without success. I am a novice in vb.net programming
I would like to display data in a rdlc report matrix, but all the data do not appear.
I have three tables in my project:

tbEleve
tbNotes
tbMaterials

I attach these three tables with the following query:

SELECT DISTINCT tbEleve.Matricule, tbEleve.Nom, tbMatieres.Matiere, tbNotes.NoteEleve, tbMatieres.Coef
FROM     ((tbEleve INNER JOIN
                  tbMatieres ON tbEleve.ID_Classe = tbMatieres.ID_Classe) INNER JOIN
                  tbNotes ON tbMatieres.ID_Matiere = tbNotes.ID_Matiere AND tbEleve.Matricule = tbNotes.MatriculeEleve)
UNION ALL
SELECT tbEleve_1.Matricule, tbEleve_1.Nom, tbMatieres_1.Matiere, tbEleve_1.ID_Notes, tbMatieres_1.Coef
FROM     (tbEleve tbEleve_1 INNER JOIN
                  tbMatieres tbMatieres_1 ON tbEleve_1.ID_Classe = tbMatieres_1.ID_Classe)

which gives me the following result in the query generator:

In short, my matrix does not display all the data of my data adapter.

What I have tried:

I have attached my tables with the following sql query

SELECT DISTINCT tbEleve.Matricule, tbEleve.Nom, tbMatieres.Matiere, tbNotes.NoteEleve, tbMatieres.Coef
FROM     ((tbEleve INNER JOIN
                  tbMatieres ON tbEleve.ID_Classe = tbMatieres.ID_Classe) INNER JOIN
                  tbNotes ON tbMatieres.ID_Matiere = tbNotes.ID_Matiere AND tbEleve.Matricule = tbNotes.MatriculeEleve)
UNION ALL
SELECT tbEleve_1.Matricule, tbEleve_1.Nom, tbMatieres_1.Matiere, tbEleve_1.ID_Notes, tbMatieres_1.Coef
FROM     (tbEleve tbEleve_1 INNER JOIN
                  tbMatieres tbMatieres_1 ON tbEleve_1.ID_Classe = tbMatieres_1.ID_Classe)

I use an access database