Unanswered: Compare two tables look for gaps, append them in new table
I'm in bit of a pickle and anyone who can solve this for me I will be greatly indebted to.
I have two tables: Actual and Schedule. My job is to compare these two tables, look for gaps, and fill them in a new table (append). Important point: tbnum corresponds to timeband. It's something I came up with to identify gaps easily. It's not permanent and Ill delete them later. I have created these sample tables: