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!