I'm currently working on a Cash Flow app in Access 2010. I've managed to put everything together (Income, Payments, Reccuring events, etc) but I'm having a bit of a problem with my final step, the pivot table.
It doesn't matter (for me) if it's a pivot form or query, but it's the only way to go for the final result and I'm stuck with simple calculations:
- daily balance
- subtracting totals
The image bellow sums up what I basically need.
Thanks in advance!!!
P.S. - You can see the fields are not in english, sorry. I tried to point out the important things in the image (Incasare = Income; Plata = Payment).