Recent content by banshee343

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...

Alright, ive got this set up using 3 querys 1 for each of the 2 "Fault"s and 1 to link them both together Problem im now having thou is that if there is data in tbldowntime for both faults my main query works fine! however if there is no data for fault1 the query dosnt return any data so when...

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...