Query help!

[EliOklesh]

Okay, maybe I'm just brain-dead at the moment, but I need some help with a SQL-related issue. (Using Access 2007)

I have the following tables:

• Agent_Data: which includes agent call statistic data
• Agent_loc: which includes each agent's site and region assignment
• Call_Type: which includes which type of call was taken (linked to agent_data table by skill)
• Bucket_: which includes ranges to classify agents based on call speed.

The end report should show how many agents by region/site, and by call type fell into each "bucket."



Since I want to display this data in Excel, it would be optimum if the Access query reported ALL regions/sites and ALL products, regardless of if anyone in a particular site took a call in that product.

I've attacked it from just about every angle I can think of, using GROUP BY and including LEFT OUTER joins, but I can't get around the same end result: only products, sites and regions in which calls were taken are represented.

I'm sure I've conquered this before on other projects, I'm just in major need of a vacation and haven't been able to put my mind 100% into these kinds of things lately.

Can anyone shed any light?

Thanks!
eo

[June7]

You don't show Products as a table in that list but then you say it has bearing on the query results. Need to analyse data. If you want to provide db, follow instructions at bottom of my post.