Hi All,
Hope everyone is doing well.
I need some help creating a "repository" staff database I'm hoping to create in Microsoft Access.
Basically, my role is to source staff to travel overseas..
The requirement is minimum 2x staff one has to be a team leader.
However, I am currently using an excel database which is noted as a "next in line list" which I've copied below
When a staff member accepts to travel overseas they are placed on the bottom of the list, pending another trip when they reach the top.
I just copy the row in excel and paste it in the bottom
Would there be an easier way to create this in Microsoft Access?
Also, when someone has accepted the trip, to automatically send a template contract when they have accepted?
Kind Regards,
Alfred