Affichage des articles dont le libellé est Crosstab Query Question. Afficher tous les articles
Affichage des articles dont le libellé est Crosstab Query Question. Afficher tous les articles

Crosstab Query Question

mardi 28 avril 2015

I have two fields:

1) DueDate
2) JobType

I want to create a query or report with Month&Year in the left hand row and JobType in the column header with a count of job types under the headers

Example:
PPM Electrical PPM HVAC PPM Fire Alarm
Apr-2015 15 5 15
May-2015 20 10 6
Jun-2015 21 7 12

I guess I'm looking for a crosstab query but I cannot figure out how to group the date by month in the query? Can anyone explain how to do this in a query or report? It would also be helpful if I could show the results in a bar chart.

I have attached a screenshots of where I am at.

Thanks, David

Attached Images
File Type: jpg CrosstabQuery1.JPG (61.0 KB)
File Type: jpg CrosstabqueryResults.jpg (92.6 KB)
Crosstab Query Question

Labels