Cash flow

[tomburns1987]

Hi,

This is my first post and am pretty new to Access. I'm an advanced Excel user and trying to get to grips with Access for work. I work in Finance and use excel to produce a cash flow analysis for each of our retail outlets. This is a repetitive process (not something i am aware a macro can solve though!) but i think it would be easier displaying the info with an access report.

I have used an import query that appends monthly figures into a table and i want my report to look at the table and lay out the info in the same way that excel was presenting it.

I have got to the point where the report shows 1 month of figures and a breakdown of expenses. The report shows this on each page for each month. Ideally i'd like it to show for one shop;

The list of expenses on the left column
then monthly figures to the right in the columns next to it in monthly order for each shop on each page.

Sorry if i've explained it badly but does anyone think they can help? Thanks in advance

Tom

[June7]

I am sure it could be done. Could it be done easily? Don't know your data well enough. Might require a combination of techniques to accomplish: subreports, VBA code, aggregate queries, report Grouping & Sorting settings.

[tomburns1987]

Thanks for the reply. I think i'm going to have to book myself on to the advance course before i can tackle this stuff.