Exporting a query with Excel formmating applied
We have a vacation bolt on module with its own custom tables. I've created a query with two unions that:
1) Parent: If applicable, returns any vacation days entered per employee
2) Union 1: If vacation time has been entered, then summarizes the total vacation time allowed for the year by employee
3) Union 2: If no vacation days are entered, then it does the same as union 1. This is because the join drops people on union 1 if there are no days in the 'vacation entered' table, so this is a duplicate to capture those people who are dropped
So the query works, extracts what I want, and displays everything I want ... but it's kind of busy. I've attached a picture with fake names to this message, but keep in mind some managers might end up with 250+ rows and 40+ employees on their file.