3 values in 1 Column - Get Count of Each Value

[Ghoztrider]

Good Morning,

I'm trying to create a query that will give me the count of how many times 3 different values show up in one field between 2 dates. I have the parameter query portion set up fine already. For instance, I have a table named JobTracker with 2 columns ( date & task). I want to create a query that gives me the count for 3 different values (edit user, edit heci, edit clli) between two dates. I want a separate columns for each value in the query.....edit user, edit heci, and edit clli respectively.



I've been messing around with a bunch of different options but can't seem to come up with anything. This should be possible, correct? I hope I've given enough information. Thanks

[June7]

Did you try CROSSTAB query?

Or try:
SELECT Sum(Iif([task]="edit user",1,0)) As CountUser, Sum(Iif([task]="edit heci",1,0)) As CountHeci, Sum(Iif([task]="edit clii",1,0)) As CountClii FROM JobTracker WHERE ...