Show years in Columns? (1 Viewer)

Hi, I have a table (Invoices Raised). I've constructed a query that extracts just the Date, Category and Amount from the table. It also groups them into years and sums the amount.

There are 1000's of entries, the dates start in 2014 to date. The Category is what the invoice was raised for Accountancy, Payroll, Tax return, Vat return...etc.

What i'm looking for is a report that will list the Category's and the totals in each year :- IE

Category 2014----------2015-------- 2016---------2017
Accounts £198,000-----£209,000----£224,000----£269,000
Payroll £49,000-------£55,000-----£59,000-----£71,000

Can anyone help me with this please?

Thanks

Add a field Year([Date]) to your query and use that query for your report.
On the report group by that field.

Date is a reserved word in Access and it isn't a good idea to use that as a field name

Use a Crosstab query based on your current query. Follow the Wizard.