Good day,
Today i come with another question, my manager needs to know how many times we did tech support on a month. so this is my database; i'm using a table called incidents on which i have 6 Fields, ID(default access field), Working_On, Date_Started, Time_Started, Date_Finished,Time_Finished.
what i have accomplished until now is to use a query to do a count function, returning me a query table with the different incidents on the Working_On field and on a second column the total of times that incident appears... what i really want to know if there's a way for my query to return the times an incident appears but by month....
For example:
Name of incident | Count January | Count February | Count March | :::::::::::::: | Count December|
i've attached the file so you can see what i mean
Count_by_date.accdb
Best regards to all