Not sure if this should be a crosstab query or not, but I can't make it work.
I have extracted some data from a table which contains two values. One is the source of the business, we'll call that field SOURCE, the other is the date the enquiry was taken. We'll call that DATE.
There are around 17 different sources of business.
The object of the exercise is to create a table where the columns are the SOURCE value and the rows are the DATE value.
Each row of DATE information has to be collated by year, so the first row is all leads taken in 2015 by source of business, the next row is 2014, etc..
How to create such a query?