Search results

I have a database with a main table with an auto number primary key, a user has overwritten a few entries in the main table accidentally, instead of creating new records. I have the original records in backed up copies of the database but because the primary key will conflict i cant just paste...

Hi im trying to have a query that reports down time for a date range [tblMain] ID ShiftDate [tblShift] ID MainID Task [tblDownTime] starttime stoptime Fault ShiftID I'm trying to make a query to display the sum of tbldowntime for each date ie.. 1/1/2010 444min 2/1/2010 323min Where...