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

0 commentaires:

Enregistrer un commentaire

Labels