Date Query

[Kelly]

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

 

[kawai6rr]

you could use something like this if you knew the date of the escalation

SELECT Glasgow, Number, date FROM what table is exists in WHERE date = 15/10/2010

syntax is missing but the idea is simple.

 

[Kelly]

Thanks but I'm looking for the query to find the record with the 3rd date so it can be found on a form which then will be updated. I am now thinking this could be done in a count query, somehow!
Cheers