I'm trying to setup a query that will return the average of a column by month. The table that I'm using for my query has a column called "Call Date" which is in the format dd/mm/yyyy, and I need it to stay in this format in the table. Right now when I run the query I'm getting the average of each column on a daily basis. Is there anyway to get the average of each column on a monthly basis?
Thanks!