Progress!
And now I need help. I made a form with a cmd button and put the following code behind the button. I can't get the time part of the date/time field to work. Almost there. HELP (and thanks in advance for Geoff and me).
Private Sub Command0_Click()
Dim dbs As Database, rst1 As Recordset, rst2 As Recordset
Dim i As Integer, timevar As Variant
Set dbs = CurrentDb
Set rst1 = dbs.OpenRecordset("tbl1")
rst1.MoveLast
rst1.MoveFirst
Set rst2 = dbs.OpenRecordset("tbl2")
Do While rst1.EOF = False
For i = 0 To 47
With rst2
.AddNew
!DataSetID = rst1.Fields(1)
!value1 = rst1.Fields(5 + i)
timevar = CDate(rst1.Fields(5 + 1))
!DataDate = Format(rst1.Fields(3) & timevar, "mm/dd/yy h:mm")
.Update
End With
Next i
rst1.MoveNext
Loop
Set rst1 = Nothing
Set rst2 = Nothing
Set dbs = Nothing
End Sub