Thanks CJ. I'm having a huge problem with the database slowing down, but I wasn't aware that it was because of my Union Queries. I'm going to try this after I'm able to send my database to Larry. Thanks for your help and suggestion!
Hi Larry - Sorry for the late reply. I've been way on travel. I can attach the shell of the database, along with some dummy records. I should have it complete and attached here today...just need to do more scrubbing first. I so appreciate your help! Just for reference, I work for a...
Okay, thanks Larry. I appreciate the response. Looks like I have a big project to do, then. And, yes, if I could lean on you for assistance, that would be great. There are some security issues....so, I need to look at the data first and determine if I can even send it to you and what I can...
Larry. You are correct. I inherited multiple tables, all of which have "some" of the same fields, hence the reason for the Union Query. There are approximately 100 tables - it's impossible to get it in a screen shot. I'm able to conditionally format a report so that it highlights those...
All,
I have a separate table for each of my programs, that includes some of the same fields, to include "Employee" name, Date, Division, and Program Name, among others. I have created a Union Query so that I can see the activity by Employee across all "Programs". How can I write a query to...