Search results

I thought it might be helpful if I included some screenshots of what I'm currently using to schedule pilots. Its basically a combination of proprietary software developed by our IT department and google sheets. On the left-hand side is the proprietary software that we use. I need to duplicate...

This looks like exactly what I needed for one aspect of scheduling. Thanks!

Thank you for this! A very comprehensive, helpful, and complete response. Your statement: "you want a list of pilots who could be assigned to take a flight on 9-Feb-2020." almost hits the mark. "Available" in my world, only refers to a pilots rotation (in my case, the 8 or 15 days that a pilot...

This was my original goal - to have a table like this. However, Access limits the number of fields to 255 (or is it 265?). I need to be able to track what a pilot is scheduled to do for every day of the year (365).

1. I don't already have times - just trying to emphasize the lack of a need for that data 2. No question - just trying to give perspective to whomever is reading 3. I have yet to learn about "do while - loop" I assume you're referring to macros 4. Maybe I shouldn't have used numbering

Hey everyone. This is my first post so forgive me if I confuse anyone (feel free to put me on blast). I'm a crew scheduler at a private aviation company with over 170 pilots. I'm trying to use MS Access to develop a pilot database/scheduling system. I have a table of all the pilots that work...