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 7 7965
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!!!
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 32,568
Recognized Expert Moderator MVP
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 12,516
Recognized Expert Moderator MVP
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?
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!
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: T Martin |
last post by:
I have a pivot table that I created using the pivot table wizard on a form.
When I open to edit it brings me to Excel where I can edit and print.
Sometimes I get an error message that says "Microsoft Excel has encountered
a problem and needs to close." I have the option of Sending Report and Not
Sending Report and I can also see the data this error report contains. Any
suggestions???
I'm running:
Windows XP Pro (SP2) - it's not...
|
by: Jerome Ranch |
last post by:
Okay
So I've got pivot tables setup in Access 2003.
Only about 30K records in the current 2005 databases...the pivots
summarize the info in a number of nice ways.
I need to get the pivot tables into a document so I can distribute the
tables, as is, as an electronic report (without the detailed data)
So I export to rtf and xls, and I get an error that there is a too
much information. I don't want all the data, just the summary table!
|
by: JayDawg |
last post by:
Is there any way to create a pivot table in a report? I have a query
with the fields Date, Name, and Data, and I am trying to create a
report that has the dates running across the top (like fields) grouped
by month, with the names running down the left, and the data values
under each appropriate month.
I am totally stumped on how to do this, other than using a Pivot Table,
but that will not suffice as this has to be created as a report.
|
by: PeteCresswell |
last post by:
I've got something called "Reference Rates".
The idea is that on a given day, we have various rates of return for
various entities.
e.g. Libor 3-month return, Libor 6-month return, US Treasury Bonds, the
Prime rate, and so-forth.
We associate a security with one of those rates.
There are a set of rates for each calendar day, and the rates for that
|
by: ze colmeia |
last post by:
Hi all,
Can anyone please tell me if its possible to have a button on a Data Access Page that when clicked passes a parameter and prints an Access Report?
Thanks in advance
| |
by: Metplant |
last post by:
I have almost no experience in ACCESS so am trying to get the system functioning with minimal operator input.
Currently I have managed to modify a database generated by a SCADA system using a query which generates a PIVOT table, grouped by DateAndTime, for all the desired data for Reporting purposes.
I have not been able to set the DateAndTime range of that data; so then a set group of data can be sent as a file to an archive location...
|
by: kabradley |
last post by:
Hello,
Thanks for looking at my post and hopefully having an answer or at least a suggestion to my problem. I currently work at a financial planning office that deals with many clients and accounts. Each client may have multiple accounts such as an individual, IRA, and possibly a joint tenant account. Each one of these accounts for the particular client is contained in a 'Portfolio'. For example, Joe Smith may have 3 accounts: Joe Smith...
|
by: stalinkakinada |
last post by:
I want to take printouts of 20000 records cards in which I need to print boths side. I prepared 2 forms(same table field are in 2 forms) each page gets 8 records . I printed one side , but when I print on the reverse of the same page records are not printing on the same back of original record. Any Suggession please ?
When I print both side It should come every records on same related record only.
|
by: cbj0517 |
last post by:
Hello:
I am trying to create a Pivot table in an Access 2003 report. I have SQL that retunrs 6 columns of data, (month_year, units, products_per_unit, gross_sales, price_pe_product, and avg_days_to_fulfill). I would like the columns of the pivot to be the months of the year, and a row for each of the other columns, with a total column at the end. It can be done in Excel, but I need it to be in a report. The crosstab query would be great,...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |