Year Count and Month Count Same Query

[NateSmith]

Hello Everyone,




I track customer claims every day. I have a database with a few years of data but only want to analyze the current month (column 2 below) and current year (column 3 below). I want to make a table with three columns:

First column: Type of claim (example shipping, packing, counting, and so on...)
Second Column: count Claims for the current month (month to date)
Third Column: count of Claims for the current year (year to date)

So As an example, it would look something like this

Claim Type	Month Count	Year Count
Shipping	3	14
Packing	1	8
Counting	2	7

**I know how to find column 2 and 3 individually, but my issue here is I cannot present this info on the same table. Can someone please tell me how I can do this so that the results of the month and year count are indepedent of each other? Currently, both columns show the month data.

[JoeM]

I already answered your question over here: http://www.mrexcel.com/forum/microso...ble-query.html