Hi I'm completely new to this and recently found myself given the task of investigating whether a database was the way to go.
I have records which are a list of faults, two fields are duplicated and the third field is the date the fault occurred
i.e
1 Glasgow 230002001 01/10/2010 13:30 01/10/2010 14:00
2 Glasgow 230002001 02/10/2010 09:00 02/10/2010 09:45
3 Glasgow 230002001 15/10/2010 12:37 15/10/2010 15:30
4 Glasgow 230002001 21/10/2010 03:00 21/10/2010 05:22
I need to extract the record for the third date occurrence as that is the escalation point for the fault.
Is this possible in a query?
Thanks
I have records which are a list of faults, two fields are duplicated and the third field is the date the fault occurred
i.e
1 Glasgow 230002001 01/10/2010 13:30 01/10/2010 14:00
2 Glasgow 230002001 02/10/2010 09:00 02/10/2010 09:45
3 Glasgow 230002001 15/10/2010 12:37 15/10/2010 15:30
4 Glasgow 230002001 21/10/2010 03:00 21/10/2010 05:22
I need to extract the record for the third date occurrence as that is the escalation point for the fault.
Is this possible in a query?
Thanks