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