Really could use some help on this one...
Is it possible to INSERT data into a report on microsoft access?

I have the report already created and data gets moved into the table that links with the report and it seems to show the data, but I would like to add two more pieces of data to it but it seems not to be working.

I would like to add the min and max time to the report which is taken from another table called MainDataLog.
VB Code:
  1. Connect.Execute "INSERT INTO Shift_Totals (" & _

  2. "MaxTime ," & _

  3. "MinTime  ," & _

  4. "Select    ," & _

  5. "MIN([TIME]) , " & _

  6. "MAX([TIME]), " & _

  7. "FROM MainDataLog"
The error I am getting is syntax error in insert into statement