1 2
| SELECT IIf(IsNull([1]),[CodeG],[1]) AS un, IIf(IsNull([2]),[CodeG],[2]) AS deux, IIf(IsNull([3]),[CodeG],[3]) AS trois, IIf(IsNull([4]),[CodeG],[4]) AS quatre, IIf(IsNull([5]),[CodeG],[5]) AS cinq, IIf(IsNull([6]),[CodeG],[6]) AS six, IIf(IsNull([7]),[CodeG],[7]) AS sept, IIf(IsNull([8]),[CodeG],[8]) AS huit, IIf(IsNull([9]),[CodeG],[9]) AS neuf, IIf(IsNull([10]),[CodeG],[10]) AS dix, IIf(IsNull([11]),[CodeG],[11]) AS onze, IIf(IsNull([12]),[CodeG],[12]) AS douze, IIf(IsNull([13]),[CodeG],[13]) AS treize, IIf(IsNull([14]),[CodeG],[14]) AS quartoze, IIf(IsNull([15]),[CodeG],[15]) AS quinze, IIf(IsNull([16]),[CodeG],[16]) AS seize, IIf(IsNull([17]),[CodeG],[17]) AS dix_sept, IIf(IsNull([18]),[CodeG],[18]) AS dix_huit, IIf(IsNull([19]),[CodeG],[19]) AS dix_neuf, IIf(IsNull([20]),[CodeG],[20]) AS vingt, IIf(IsNull([21]),[CodeG],[21]) AS vingt_un, IIf(IsNull([22]),[CodeG],[22]) AS vingt_deux, IIf(IsNull([23]),[CodeG],[23]) AS vingt_trois, IIf(IsNull([24]),[CodeG],[24]) AS vingt_quatre, IIf(IsNull([25]),[CodeG],[25]) AS vingt_cinq, IIf(IsNull([26]),[CodeG],[26]) AS vingt_six, IIf(IsNull([27]),[CodeG],[27]) AS vingt_sept, IIf(IsNull([28]),[CodeG],[28]) AS vingt_huit, IIf(IsNull([29]),[CodeG],[29]) AS vingt_neuf, IIf(IsNull([30]),[CodeG],[30]) AS trente, IIf(IsNull([31]),[CodeG],[31]) AS trente_un
FROM [Copie de R_Planning_Analyse croisée(1)]; |
Partager