Hello Experts,
Thanks to all who helped me out in past. I would say this is the best place to get your answers
Need your help again ....
I have a database where there is a table in which there are some set of data. Now I want a query (LastestInception) to display only the lastest "Inceptiondate" wise when following fields "IMO", "DateOfLoss" and "LossDescription" data are same:
If there are multiple records for the same "IMO", "DateOfLoss" and "LossDescription", then only the youngest record (in terms of "InceptionDate") needs to be considered. E.g. For DoneYear 2008, for IMO = 9235983, DateOfLoss = 8/11/2008 & LossDescription = 'Crack in ballast tank', there are two records with Relevant_Inception
- 01/01/2010
- 01/01/2011
In this case, only the youngest record, i.e. InceptionDate = 01/01/2011, should be considered. Please see the snapshot as well as sample database. Also if any record is single and there is no any matching records, It should also be taken in query.
Hope I have explained my problem correctly. I shall be much obliged for prompt reply.
Thanks you in advance.
Santosh
Thanks to all who helped me out in past. I would say this is the best place to get your answers
Need your help again ....
I have a database where there is a table in which there are some set of data. Now I want a query (LastestInception) to display only the lastest "Inceptiondate" wise when following fields "IMO", "DateOfLoss" and "LossDescription" data are same:
If there are multiple records for the same "IMO", "DateOfLoss" and "LossDescription", then only the youngest record (in terms of "InceptionDate") needs to be considered. E.g. For DoneYear 2008, for IMO = 9235983, DateOfLoss = 8/11/2008 & LossDescription = 'Crack in ballast tank', there are two records with Relevant_Inception
- 01/01/2010
- 01/01/2011
In this case, only the youngest record, i.e. InceptionDate = 01/01/2011, should be considered. Please see the snapshot as well as sample database. Also if any record is single and there is no any matching records, It should also be taken in query.
Hope I have explained my problem correctly. I shall be much obliged for prompt reply.
Thanks you in advance.
Santosh