1 2 3 4 5 6 7 8 9 10
|
PARAMETERS [Caractères cherchés :] Text;
SELECT "L3S" as IdUtil, DateInfo, Info, Confidentiel, NomLabo
FROM Labos INNER JOIN ReportingL3S ON Labos.IdLabo = ReportingL3S.RefLabo
WHERE (((Info) Like"*" & [Caractères cherchés :] & "*") AND ((Labos.IdLabo)=[RefLabo]))
UNION ALL
SELECT "LCE" as IdUtil, DateInfo, Info, Confidentiel, NomLabo
FROM Labos INNER JOIN ReportingLCE ON Labos.IdLabo = ReportingLCE.RefLabo
WHERE (((Info) Like"*" & [Caractères cherchés :] & "*") AND ((Labos.IdLabo)=[RefLabo]))
ORDER BY DateInfo DESC; |
Partager