So I’m fairly new to Access in general (the last time I used it was in high school) and I want to create a report for my database that summarises the incomings and outgoings of an organisation I volunteer with.
I haven’t fully built the database yet, but here’s a snippet example of what I have. Sorry for the bad formatting, I’m typing this on mobile.
LABEL DATE AMOUNT
A 01/01/2011 50
B 02/01/2011 23
C 03/01/2011 -35
E 04/01/2011 -56
D 05/01/2011 73
And so on.
I’m trying to create a report that takes this information and groups it into categories based on their value like this:
***
COMMENT:
(Some form of text here that I can type)
>PAGE BREAK<
TOTAL INCOME: +146
A 01/01/2011 50
B 02/01/2011 23
D 05/01/2011 73
TOTAL EXPENDITURE: -91
C 03/01/2011 -35
E 04/01/2011 -56
NET CHANGE: +55
***
If possible I would also like to be able to filter this by date as I’m required to produce these reports every quarter.