I
Inma
Hi,
I've Orders and Agents tables joint in a query. The Agents table has
AGENT_ID and MNGR_ID. The query pulls the monthly orders per Agent. Some
Agents have sub Agents and I differentiate them with the MNGR_ID. So what I
need to accomplish is to pull the orders of all the Agents and sub Agents
but, the latter, should be grouped as an Agent having MNGR_ID = 35.
I cannot seem to accomplish such task. I'd appreciate some help.
TIA
Inma
I've Orders and Agents tables joint in a query. The Agents table has
AGENT_ID and MNGR_ID. The query pulls the monthly orders per Agent. Some
Agents have sub Agents and I differentiate them with the MNGR_ID. So what I
need to accomplish is to pull the orders of all the Agents and sub Agents
but, the latter, should be grouped as an Agent having MNGR_ID = 35.
I cannot seem to accomplish such task. I'd appreciate some help.
TIA
Inma