Query trouble

[kfurlong]

 

• • • • Hello everyone,
        I am having trouble writing a query. I can write simple ones, but I am getting a little overwhelmed with these. Basically here is what I have
        completion_counter_data:
        

Date |	Status_Name |	Department |	Cell |	Assembly |
Todays Date	Completed New	Department	Cell	Assembly
Todays Date	Completed Rework	Department	Cell	Assembly

Todays Date	Failed	Department	Cell	Assembly
Todays Date	Failed	Department	Cell	Assembly
Todays Date	Failed	Department	Cell	Assembly
Todays Date	Failed	Department	Cell	Assembly

 
Basically I want to select the number of rows for each Status_Name for each Assembly for each cell with a static department in a specific date range.  So the example table above would return
---------------------------------
Department
---> Cell
----------->Assembly
-------------------->Completed New
------------------------------>1
-------------------->Completed Rework
------------------------------>1
-------------------->Failed
------------------------------>4

 

 

 

 

 

But there will be more assemblies. in each cell and more cells in a static department.

 

I have another query problem, but maybe it can be solved by knowing th answer to this.

 

Any help is greatly appreciated!

[fenway]

Then you need to use GROUP BY.