Recent content by codeliftsleep

My apologies, I wasn't aware of this rule. However, even if I was, there is little I could do about it since I can't post links yet. In fact I actually had to delete the links you provided to quote you.

Unfortunately I don't control how the tables were built, I simply have to get this working as is... Would a subquery be preferable to a second LEFT JOIN?

I have three tables I am working with where I need to join together various data in a query. I have an accounts table, an Employee Averages table and a Client Table. I have a UDF called GetCurrUser() which I use in the query, which returns the user's EmployeeId via the Environ("username")...

OK I did that and am getting the correct value, but how to add it to the report? The report is pulling from the original query and when I attempt to add the new query column in the textbox it gives me the pop-up input box asking for a value... I tried adding it to the original query but then...

Having some issues with this and I know the answer is really easy, but I can't seem to get it right. I have a report based on a query where it groups by Employee and also Customer Tier. We have 2 Tiers, 1 and 2. Each employee is responsible for handling a number of clients in each tier, and we...