Generate a field in query, with hourly incremented data between MIN MAX interval

[MariUSD]

How can I put a field in my query, with all data hourly incremented between 01 January 2015 to 31 December 2015.



Please forgive my inability.

[June7]

A SELECT query can't create records.

What exactly do you mean by 'all data hourly incremented'? What data do you have? Show examples of raw data and desired output.

[MariUSD]

A SELECT query can't create records.

What exactly do you mean by 'all data hourly incremented'? What data do you have? Show examples of raw data and desired output.

Like in Excel. A series begin with 01.01.2015 00:00; 01.01.2015 01:00; 01.01.2015 02:00;... to 31.12.2015 23:00.

My server receives data via antenna. Sometimes the signal is missing and needs to introduce averages for missing times.
Thank you for your interest.

[June7]

Still not enough info.

What do you mean 'like in Excel'? How does Excel pertain to your Access data?

That still doesn't show example of your raw data and desired output.

What does 'introduce averages' mean - do you need to create records?

[MariUSD]

Yes, I need to create records from 01.01.2015 00:00 incremented by 1 hour, to 31.12.2015 23:00. For each record must be populated with registered value or calculated (averaged) value in missing case.

[June7]

So create records only for missing time slots? Will require VBA procedure. Something like:

Public Sub Times()
Dim dateStart As Date, dateEnd As Date
dateStart = Me.tbxStart
dateEnd = Me.tbxEnd
Do While dateStart < dateEnd
   If IsNull(DLookup("ID", "tablename", "datefield=#" & dateStart & "#")) Then
      CurrentDb.Execute "INSERT INTO tablename(datefield) VALUES(#" & dateStart & "#)"
   End If
   dateStart = DateAdd("h", 1, dateStart)
Loop
End Sub