select
  [Показания].[Дата],
  max(iif(1 between [Начальный час] and [Конечный час], [1], 0)) as [1],
  max(iif(2 between [Начальный час] and [Конечный час], [2], 0)) as [2],
  max(iif(3 between [Начальный час] and [Конечный час], [3], 0)) as [3],
  max(iif(4 between [Начальный час] and [Конечный час], [4], 0)) as [4],
  max(iif(5 between [Начальный час] and [Конечный час], [5], 0)) as [5],
  max(iif(6 between [Начальный час] and [Конечный час], [6], 0)) as [6],
  max(iif(7 between [Начальный час] and [Конечный час], [7], 0)) as [7],
  max(iif(8 between [Начальный час] and [Конечный час], [8], 0)) as [8],
  max(iif(9 between [Начальный час] and [Конечный час], [9], 0)) as [9],
  max(iif(10 between [Начальный час] and [Конечный час], [10], 0)) as [10],
  max(iif(11 between [Начальный час] and [Конечный час], [11], 0)) as [11],
  max(iif(12 between [Начальный час] and [Конечный час], [12], 0)) as [12],
  max(iif(13 between [Начальный час] and [Конечный час], [13], 0)) as [13],
  max(iif(14 between [Начальный час] and [Конечный час], [14], 0)) as [14],
  max(iif(15 between [Начальный час] and [Конечный час], [15], 0)) as [15],
  max(iif(16 between [Начальный час] and [Конечный час], [16], 0)) as [16],
  max(iif(17 between [Начальный час] and [Конечный час], [17], 0)) as [17],
  max(iif(18 between [Начальный час] and [Конечный час], [18], 0)) as [18],
  max(iif(19 between [Начальный час] and [Конечный час], [19], 0)) as [19],
  max(iif(20 between [Начальный час] and [Конечный час], [20], 0)) as [20],
  max(iif(21 between [Начальный час] and [Конечный час], [21], 0)) as [21],
  max(iif(22 between [Начальный час] and [Конечный час], [22], 0)) as [22],
  max(iif(23 between [Начальный час] and [Конечный час], [23], 0)) as [23],
  max(iif(24 between [Начальный час] and [Конечный час], [24], 0)) as [24]
from 
  [Параметры]
  inner join [Показания] on [Параметры].[Дата] = [Показания].[Дата]
Group By
  [Показания].[Дата]