This should be easy, but I'm missing something. I have a UNION query that is combining 3 tables with identical fields.
On my form I have a control box that I want to use to display the COUNT of all employees hired within a certain date.
I can handle the COUNT part with no trouble, but I can't figure out how to add the filter (if it actually is a filter).
I could write the UNION query this way, however I don't want to get too specific because I want to come up with other calculations and the less queries I'm having to make the better. What would be perfect is if I could have a form that showed the result of several formulas coming from several different UNION queries. In other words, can I create unbound control boxes and have them linked to several different queries, and does it matter that they are UNION?
I know this is a two-part question (at least 2 parts!) but I'm not sure where to go from here. Any help is most welcome!
On my form I have a control box that I want to use to display the COUNT of all employees hired within a certain date.
I can handle the COUNT part with no trouble, but I can't figure out how to add the filter (if it actually is a filter).
I could write the UNION query this way, however I don't want to get too specific because I want to come up with other calculations and the less queries I'm having to make the better. What would be perfect is if I could have a form that showed the result of several formulas coming from several different UNION queries. In other words, can I create unbound control boxes and have them linked to several different queries, and does it matter that they are UNION?
I know this is a two-part question (at least 2 parts!) but I'm not sure where to go from here. Any help is most welcome!
