I don't think this is going to be too rough, though I am not seeing it in the asked questions and answered questions.
I am looking for a way to group by sales person for two different types of sales.
So something like
Name PendingORders CompletedOrders TotalOrders
Grouped by the Name first, Count Type = P, Count = C and then sum Type= P and count = C.
Though there are only two types of orders in this report so technically the criteria is just a count of all orders by the name.
My table, would look like this
Name|Order#|Type Jane| 1 | C Jane| 2 | P Jane| 3 | P Fred| 4 | P Fred| 5 | P
Hopefully the query would produce
Name|TotalOrder|Pending|Completed Jane|3 |2 |1 Fred|2 |2 |0
Many thanks in advance