1 2 3 4
| INSERT INTO Tbl_epure_64431 ( Format, Champ2, Champ4, Champ6, Champ8, Champ10, Champ12, Champ14 )
SELECT IIf([Champ4]="Imprimer/copier(+grand qu'A4/Letter)Limite(Monochrome)","A3",IIf([champ4]="Imprimer/copier(A4/Letter et +petit)Limite(Monochrome)","A4","")) AS Format, [34416443_printlimitation].Champ2, [34416443_printlimitation].Champ4, [34416443_printlimitation].Champ6, [34416443_printlimitation].Champ8, [34416443_printlimitation].Champ10, [34416443_printlimitation].Champ12, [34416443_printlimitation].Champ14
FROM 34416443_printlimitation
WHERE ((([34416443_printlimitation].Champ8) Is Not Null)); |
Partager