Search results

Cheers. I thought that might be a typo and tried the first change you suggest. Access didn't like it. The second one gave me the same results as "=" So, I tried opening up the dateadd figure in case the formatting of my table was wacky but checked it is standard time. Anyway, when I try 1000 it...

Thanks for that. I have inserted as below but get an error message saying.... Between operator without And in query expression 'A.[TIME] BETWEEN A.Tim' SELECT Fault_List.Serial, Fault_List.Time, Fault_List.Fault FROM Fault_List INNER JOIN Fault_List AS A ON A.[Time] BETWEEN A.Time AND...

So, I have it checking the alias for the same time but struggling with the time window part. Probably a more than less than? But seem to be making some typos as can't get it to work....... I have: SELECT Fault_List.[Time], Fault_List.[Serial] FROM Fault_List INNER JOIN Fault_List AS A...

Cheers, sounds like a great starting point. I can probably fumble my way through that. Any example of code welcome, how do we query "within 5 seconds"?

If fault occurs, is it on it's own?(no other faults within 5 seconds). If so, lookup table 2 for combin number. (Some combins will just be one fault, but another element is that these faults will also be part of other combins that I am checking next)) If fault occurs with others (within 5...

Hi Guys, Wondering if you can help me. I am new to the forum and like to use access as a drag and drop query man with some muddling through with SQL union queries and suchlike. Keen to take it further though. So, I have some fault code data to analyse with date and time stamp. I will be...