Here is the actual sql statement:


db.Execute "SELECT * INTO Times IN '" & strTempDb & "' FROM Times WHERE DatePerformed>=#" & Format(date1.Value, "mm/dd/yyyy") & "# AND DatePerformed<=#" & Format(date2.Value, "mm/dd/yyyy") & "#"

from the db i want to pull out lastname, dateperformed, regularhours, overtimehours fields....


This query takes a snap shot of the selected criteria and places it into a temp mdb...