Print a Report from a Pivot Table in Access 2010?

[dgaletar]

To start off, I am a serious "newbe" to Access, and have probably made countless mistakes thus far in the design of this database.

I work as a fleet mechanic for a University in DC, and am trying to keep track of the maintenance on our vehicles. To do this I created a pretty simple Access 2010 database.

Everything was going pretty well until I realized that I couldn't go any further without some help... so here I am!

In an effort to maintain an inventory of certain parts for our fleet (i.e. tires, oil filters, etc.), I need to count how many of each item we should keep in stock. In the tables & forms that I created thus far I log all of these details. I have one main table for the vehicles themselves, one sub-table for the specific "drivetrain" information for each, and another sub-table with the specific parts that each vehicle requires.

Now I need to know how many of each of those items we should keep in stock. To do this I tried (unsuccessfully) to create a query, but that did not work. So I found an article entitled "Instead of queries, use the Access 2007 PivotTable view" which did the job PERFECTLY!

But now, the only way to see the results outside of these PivotTables seems to be to extract the results into Excel.

What I would REALLY like to be able to do is to "Print" (or View) a report that shows these results.

Can anyone help me to figure this out???

Thank you in advance for your assistance.

dgaletar

[dgaletar]

OK, I just figured out how to do this (http://www.techrepublic.com/article/...eports/6097020), but now my PivotTable is not working properly!?!

Can anybody please help me figure this out?

dgaletar

[dgaletar]

Here's where I am with my PivotTable: (see attachments)

So I now have it to where the PivotTable shows which vehicle uses which tire, but I'm looking for a total number of vehicles for each tire (i.e.: the tires 195/75R/14 and 205/70R/15 are each used by 2 vehicles; while the tire 205/75R/15 is used by 4 vehicles).

I feel like I'm sooooo close!!!

[dgaletar]

OK, now I'm getting somewhere!!! I figured out that if I also add the "Tires" field to the "Data Area", it totals each tire individually like I'm looking for.

Now to the report aspect of this!

(BTW, if anyone knows an easier (or better) way to be doing this, PLEASE let me know!!!)

[NeoPa]

Not sure why no-one's jumped in yet. It's a well asked question - better than most. I've just updated a couple of your posts so the pictures show, but i don't play with P Tables I'm afraid. Good luck anyway :-)

PS. It's very atypical to have a thread go so long without help. It was a very busy day though, so maybe tomorrow.

[Rabbit]

I think help is slow because not a lot of people use pivot tables. It seems like the issue you are currently having has moved away from the original topic. Would you mind creating a new thread for your current issue and put a link to this one for background?

[dgaletar]

Following your request:

THREAD 1 OF 2 - How Do I Create Report Our Inventory: http://bytes.com/topic/access/answer...-our-inventory

THREAD 2 OF 2 – Table Relationships for a Newbie: http://bytes.com/topic/access/answer...onships-newbie

Thanks

[GEL67]

Hi there...this question has been out here for a long time; I just now came across it. Let me tell you how I manage to print charts/graphs. Access misleads us with their auto generated bar/chart form into thinking we can print from that form...we can't. The way to generate a bar/chart that you can actually view AND print....is to start with a blank form. Go into that form and insert a graph from there.

Once you go into the design view of your form inside the Form Design Tools you will see the icon for a bar chart...this is the way you want to go. Just insert your chart and format from there. I like this approach better too because for my end users I can actually insert buttons that help them export to pdf or print if they want (and no, those aren't visible when the form is printed ;-) Good luck!