Building a report

[cbende2]

Hello all,

I'm building a report for my sample database before moving on to my actual database, and I need help with it. I'm fairly certain this will involve coding in VB, and I have very little experience with it.

Here is my database:TestingReports.zip



I want to design a report that ends up looking like this: TestingReportsExcel.zip

I manually did it in excell for my sample database to just show you guys what I would like for my report in access to look; but in my actual database, I have over 350 plans and 10+ trading partners and 10+ administrators, hence the reason I'd like to have a button to click to calculate these things up and print a report on it.

Any help will be greatly appreciated!

EDIT: To explain what I'm trying to do: I have PlanTable with fields [PlanName], [TradePartnerID] and [AdminID], I have TradePartnerTable with fields [TradePartnerID] and [TradePartner], and I have AdminTable with fields [AdminID] and [AdminName].
I'm trying to build a report that gives me a view seeing how many plans the administrators handles, the TradePartner of the plans the administrator handles and a total of all the plans.

It is easy to see what I'm looking for in the second attachment, I kind of manually created the report inside excel and actually counted up the values that match.

[ranman256]

You want a CROSSTAB query. But 1st...you need a query to join your tables and the get the values...say: [person],[co], [amt]. Call it Q1

Now use the query wizard to create a crosstab using Q1.
Names as columns
Co as rows
Values at the intersections.

Once you have the crosstab query, you can make a report.

[cbende2]

How do I get the [amt]? I'm assuming thats the amount of how many plans that person has with a specific company? How do i get that?

Thanks for the reply by the way.

EDIT: I got it, but now how do I get the total values to show up?

Like so:

[June7]

Try textboxes in form footer section with expressions in ControlSource, like: =Sum([Bob])

[cbende2]

Thanks! It worked!