Search results
-
C
Query with 2 LEFT JOINS to different tables not bringing back what I want
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")...- codeliftsleep
- Thread
- Replies: 9
- Forum: Queries
-
C
How to get an average of two groups?
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...- codeliftsleep
- Thread
- Replies: 3
- Forum: Reports