Does anyone knows how to make query for find records which are the last record. Let's me make an example :
I have database for transaction :
Transc _no Equipment_no Repair_date finish_rep
1 1000001 01/02/02 01/05/02
2 1000001 01/10/02 01/11/02
3 1000002 01/20/02 01/21/02
4 1000001 01/15/02 01/16/02
5 1000002 01/22/02 01/23/02
the example shows that equipment_no 1000001 has 3 times repair and I want make query to get only it's last transaction. So the query only show :
4 1000001 01/15/02 01/16/02
5 1000002 01/22/02 01/23/02
Would you please help me how to make this kind of criteria or what should I put in criteria rows in query ???
I have database for transaction :
Transc _no Equipment_no Repair_date finish_rep
1 1000001 01/02/02 01/05/02
2 1000001 01/10/02 01/11/02
3 1000002 01/20/02 01/21/02
4 1000001 01/15/02 01/16/02
5 1000002 01/22/02 01/23/02
the example shows that equipment_no 1000001 has 3 times repair and I want make query to get only it's last transaction. So the query only show :
4 1000001 01/15/02 01/16/02
5 1000002 01/22/02 01/23/02
Would you please help me how to make this kind of criteria or what should I put in criteria rows in query ???