Howdy,

I'm working on creating a Net Cash report that includes about 50 companies and their investments (ranging from 1 to 20 investments each) that lists the total cash investment for each year which varies depending on the company. Trouble is I'm just learning access and for the life of me can't figure out how to do this.

I want one company per page and I don't want the report to list every year because some of the companies may only have existed for one year while others may have been created 15+ years ago. Also the top portion of the report should display the Company and the lower part should horizontaly display the year with the net cash invested for each investment vertically below it. Does that make sense...I'm not good at describing this :p .

I've been trying to figure out how to do this based on the sample crosstab database I found here (http://www.access-programmers.co.uk/forums/showthread.php?t=62587) but that doesn't solve my changing years problem.

Like I said I'm very new to this stuff (I'm only an accountant pretending to know what I'm doing).

Thanks for any help you can give,
Krisha

Have you ever created a table, query or form in Access? (From scratch, not a wizard)

ken

Yes, I have done all of those before.

Sorry, didn't mean to be rude - you just never know...

Then by the first line of your post:

I'm working on creating a Net Cash report

I'll assume you have your db built and just need to do a report. If so what tables/fields do you have?

ken

Sorry, didn't mean to be rude - you just never know...
No, no that wasn't rude, I should have mentioned that I'm not totally new at this, I learned a lot of this in school but it was really simple stuff and this is way outside of my present skill set.

I suppose I should have described the database a little better. What I have is a HUGE database that we've had someone else build for us to track our investments and investors; the reports that I am trying to create reflect the company and all of the investments and the cash invested/distributed. We were doing everything manually in Excel and that was taking too much time so it became my job to take the reports that we were creating in Excel and recreate those using Access.

For the Net cash Report I want to use the fields for the company name (DBAName), the Investment(combination AccountKey and SubAccountKey), the Year, and the net Amounts for transactions labled Cash Contribution and Cash Distribution for each year. I had to create a query first so that I would only have the yearly totals (instead of each individual transaction) for Contribution and Distribtuion transactions only. See why I'm so confused yet...? T

hen I used the report that I linked earlier as a template for the report that I needed to create, but the problem is that it lists all possible years and I need only the applicable years for each company and it doesn't account for a heading (which changes on each page).

Hope that was a little more clear. Thanks again for any help.

- Krisha -