Hello,

I've been working on one particular query that gives me so much trouble.

SELECT Cheque.DATEDEPOT, RapportFiduciePart5.IDGROUPE,
RapportFiduciePart5.IDDOSSIER, RapportFiduciePart5.NOCHEQUE,
RapportFiduciePart5.montantClient AS MontantTot,
RapportFiduciePart5.chequeRemis, RapportFiduciePart5.nomComplet,
RapportFiduciePart5.DATEDEPOT AS DateDuDepotDuCheque,
RapportFiduciePart5.IDCHEQUE
FROM Cheque
INNER JOIN RapportFiduciePart5
ON "" & Cheque.IDCHEQUE="" & RapportFiduciePart5.refNSF;



SELECT Cheque.IDGROUPE, Cheque.IDDOSSIER, Cheque.montantClient,
Cheque.IDCHEQUE, Cheque.NOCHEQUE, Cheque.Concdate, Cheque.montant,
[prenom] & " " & [nom] AS nomComplet, Cheque.MontantClient_Dispo,
Cheque.intrust, Cheque.HNFrais_Dispo, Cheque.groupeChequeClient,
Cheque.groupeChequeHonoraire, Cheque.groupeChequeHN, Cheque.montantHN,
Cheque.ConcYesNo, Cheque.NSF, Cheque.chequeRemis, Cheque.refNSF,
Cheque.DATEDEPOT, Cheque.chkDossier, Cheque.depot, Cheque.validationDepot,
Cheque.percepteur
FROM Cheque INNER JOIN PersonnesDébiteurs ON Cheque.IDCHEQUEDEBITEUR =
PersonnesDébiteurs.IDDEBITEUR
WHERE
(((Cheque.Concdate)<[Forms]![VérificationConciliationMensuel].[Form]![dateBox])
AND ((Cheque.NSF)="1") AND ((Cheque.chequeRemis)="1") AND
((Cheque.refNSF)>0) AND ((Cheque.chkDossier)="1") AND ((Cheque.depot)="1")
AND ((Cheque.validationDepot)="1") AND ((Cheque.percepteur)="Fiducie"));