Okay, here's the sample revised. You should be able to copy the union query to your real db. You would need to relink the Excel spreadsheets in the sample to get the sample to run.
You also had forgotten to change frmRange in the part for the End Date to just Range. That is why the start date didn't give a prompt but the End Date did.
I know the feeling. Plus, as you found out - it took a very short time to fix it once I was able to actually see it and test it. I am way more "visual" when it comes to things like that. If I can see it, I am much better off then trying to do the questioning path.