Dear All
Have one table with information of crew.
crew keep joining and leaving.
The table is sorted according to rank-code, like master as 1 and steward as say 40; sorted by the joining date. Also have a field for disembarking date.
I am having problem in doing this bcos:
a) once I sort in the query according to rank-code and then by joining-date; it invariably keeps the three men joined as seaman all together bcos of the rank-code and unable to get the three seaman to be at the end of the last month crew.
What is needed is :
1. query to have list of crew for the month in such a way, all those who have disembarked to be in the same order as the last month; all the new joiners for the month to be listed below the last month crew onboard; in such a way the list will show all the crew for the current month brought forward from last month plus the list of new crew at the bottom.
2. why such a table is required is bcos this crew list is linked to one excel where each persons stores purchased record is maintained. Against the names the entries are made and it will be easier to just add new crew members at the bottom and continue filling the purchase quantities and amount.
Pls help
Brgds/captgnvr