I have a table which I want to compare the time of two rows, and if the time is within 10 seconds return the two rows and ignore the other rows.
i.e. from the table below it would return rows 3 & 4..
Row Date Computer message
1 28/08/2012 22:11:23 Comp1 Problem resolved
2 28/08/2012 22:10:18 Comp1 Problem Started.
3 28/08/2012 21:35:46 Comp1 Problem resolved
4 28/08/2012 21:35:45 Com1 Problem Started.
I must admit it has been a few years since I played with access
i.e. from the table below it would return rows 3 & 4..
Row Date Computer message
1 28/08/2012 22:11:23 Comp1 Problem resolved
2 28/08/2012 22:10:18 Comp1 Problem Started.
3 28/08/2012 21:35:46 Comp1 Problem resolved
4 28/08/2012 21:35:45 Com1 Problem Started.
I must admit it has been a few years since I played with access