Hello,

I have the following query:

select nomEtudiant, prenom, commentaires, dateBenevolat, nbHeuresEstimee, nbHeuresReelle, description, etatProjet
FROM Projet, ProjetEtudiant, Etudiant as etud, NiveauEtudiant, Niveau
WHERE Etudiant.noEtudiant = ProjetEtudiant.noEtudiant AND
ProjetEtudiant.noProjet = Projet.noProjet AND
ProjetEtudiant.etatProjet IN(1,2) AND
[Etudiant].[noEtudiant] = [NiveauEtudiant].[noEtudiant] AND
NiveauEtudiant.anneeDeSecondaire = Niveau.anneeDeSecondaire AND
date() between Niveau.debutDesCours AND Niveau.finDesCours AND
( Select SUM(ProjetEtudiant.nbHeuresREelle) from ProjetEtudiant, Etudiant Where Etudiant.noEtudiant = ProjetEtudiant.noEtudiant AND [ProjetEtudiant].[noEtudiant] = etud.noEtudiant) > 1;

for the following db [attached]

Why do I get prompted for entering Etdiant.noEtudiant when I expect it to display not one but all the records which match the criteria?

Thanks!
Andrei

I suspect the noEtudiant is not a field in table Etdiant. I didn't look at your attackment.