Confusing Data Issue

[sstidham]

So my boss has asked me to make him a database so we can sort our Agents by ranking based on their sales. I have managed to get the database to import all the data needed correctly, the issue is now how best to utilize this data.

Essentially we have 2 reports that are reporting each product the agent sold. Each product is broken up into at least 2 categories on each report for example: Digi Cable U, Digi Cable I (U-upgrade, I install), would both be considered Video. Each individual sale for each agent is its own seperate row, so the same Agent could have 10 rows of data.

Here is what I'm having trouble wrapping my brain around. Essentially I need this condensed to do a total count for each product type for each agent (essentially each agent has one row with thier sales totaled for each product type for the month), and then the ability to sort this same data so that the person with the highest sell in percentage wins.

I have a feeling I'm going to need to utilize several queries to accomplish this, but I'm unsure of where to start. A push in the right direction would be helpful! Thanks so much!

[JustJim]

So my boss has asked me to make him a database so we can sort our Agents by ranking based on their sales. I have managed to get the database to import all the data needed correctly, the issue is now how best to utilize this data.

Essentially we have 2 reports that are reporting each product the agent sold. Each product is broken up into at least 2 categories on each report for example: Digi Cable U, Digi Cable I (U-upgrade, I install), would both be considered Video. Each individual sale for each agent is its own seperate row, so the same Agent could have 10 rows of data.

Here is what I'm having trouble wrapping my brain around. Essentially I need this condensed to do a total count for each product type for each agent (essentially each agent has one row with thier sales totaled for each product type for the month), and then the ability to sort this same data so that the person with the highest sell in percentage wins.

I have a feeling I'm going to need to utilize several queries to accomplish this, but I'm unsure of where to start. A push in the right direction would be helpful! Thanks so much!

Hi,

Here's the telling point

the same Agent could have 10 rows of data

Please read this very useful article, then walk around the block and read it again. No, seriously, it takes a couple of readings (unless you're Einstein).

It'll be worth it though.

Jim