Salut,
c'est donc une requête sélection Access :
Voici le code SQL de la requête :
SELECT Date() AS [DATE], [PRC EXPRESS A].CODEL, [PRC EXPRESS A].NOMDEL, [PRC EXPRESS A].CORBEILLE, [PRC EXPRESS A].GESTIONNAIRE, [PRC EXPRESS A].GROUPE, [PRC EXPRESS A].NO_DOS, [PRC EXPRESS A].NM_PRN, [PRC EXPRESS A].COD_NIR, [PRC EXPRESS A].DOS_REF_IRC, [PRC EXPRESS A].COD_IRC_MAJ, [PRC EXPRESS A].COD_TYPE_DOS, [PRC EXPRESS A].NO_, [PRC EXPRESS A].COD_NIV_DOS, [PRC EXPRESS A].COD_STATUT_DOS, [PRC EXPRESS A].A01, [PRC EXPRESS A].A10, Date()-[A01] AS AGE, IIf([DAT_EFET_DMD_ARRCO]>Date(),1,0) AS Test, [PRC EXPRESS A].DAT_EFET_DMD_ARRCO, *
FROM [PRC EXPRESS A]
WHERE ((([PRC EXPRESS A].COD_IRC_MAJ) Between "A015" And "A01599" Or ([PRC EXPRESS A].COD_IRC_MAJ) Between "C011" And "C01199" ) AND (([PRC EXPRESS A].COD_NIV_DOS)<>"X" ) AND (([PRC EXPRESS A].A10) Is Null) AND ((Date()-[A01])>23) AND ((IIf([DAT_EFET_DMD_ARRCO]>Date(),1,0))<>1));
je dois créer un champ spécial ou insérer en SQL ?
Merci de ton aide olivthill