I have some machine data to display showing running speeds. This is logged every minute when the machine is running but not when stopped.
how do I display a bar graph with a timescale along the bottom of minutes showing gaps when the mchine is down. :confused:
Basically I have a table setup where Time Fields are stored. What I need to do is in a Query, have the difference of two Time Fields calculated, and then displayed on a Report. Here's what I have so far...
Table
- Start Time
- End Time
Query
Difference Time: DateDiff("n",[Start Time],[End Time])
All that works fine and shows up on the report, except for the fact that the time is showed in straight minutes, so for a difference of 1:30 minutes, it just shows 90 minutes. I need to make it so that on the report in the Difference Time Text Box, it's showed as 1:30 instead of 90.
I tried putting the following in the Control Source for the Difference Time Text Box on the report, but it returns an error.
=[Difference Time] 60 & Format([Difference Time] Mod 60, ":00")
How can I convert hours and minutes to minutes as an Integer?
For example, convert 2:15 to 135.
Any help is greatly appreciated.
I have created a table in Access with the data I need to put into a line graph.
The data is in this format:
[Table]....
This just a snapshot of the data. What i would like to do is produce seperate line graphs for each town, charting the temperatures over the three years. Because there is so much data i need to find a way which can produce graphs on mass.
is it possible to place a graph from Excel in an Access report? instead of using the Access pivot charts?
Thanks
Kevin
I am not sure where to post this so could someone please move it to the appropriate area thanks.
I want to make a graph that will show how many employees are in the company for each year (Going back 10 years and keeping up to date) I have never done this before and our teacher feels that its best if we learn on our own (basicaly he's an idiot).
How do I go about using the pivot chart?
I have made a query which adds up the total number of employees at the current time.. but apart from that I havent a clue. I want the graph to have the years on the bottom and numbers up the side (1,2,3,4,5 etc) and then the number of employees that were in the company during that year will be plotted.
I will use a table that is to be used for archiving to mke the query as it will have all the employees who were ever in the system record.
The table is thus:
Employee_ID
Emp_First_Name
Emp_Surname
Age
Emp_Home_Number
Emp_Mobile_Number
Emp_Address_1
(so on and including postcode)
Date_Started
Position_ID
I have no idea what to do other than to rename the axes and change the increments, but they are jsut numbers, no dates or anything.
Any help apreciated.
Hi All,
This is a simple problem i think....but am struggling to find a variable to change!.
The problem is that i have a chart on a form, but the chart is replicated 22 times (i.e 22 charts on seperate pages)...there should only be 1!
I have 22 variables on the X-Axis...so am presuming it is linked to that somehow. am also graphing off a crosstab.
I am still searching for a solution myself...but thought i'd ask in here incase anyone has any ideas/experience of this problem!
Thanks!
I am a bit of a db virgin! So I would appreciate some assistance please.
I am trying to display a graph in the form view of a db.
The db is comprised of a standard form and table set up but the data comes from a series of linked excel spreadsheets.
Basically it is a way of displaying student data for parents evenings at school and I would like a graph to make it the data more visual.
can anyone help?
I do not know why this has been so difficult. I have search google and even this forum. There is no clear cut explanation on how to build a button on a form to export a pivotchart to a jpg. Does anyone know how this can be done. please show code.
View 1 Replies View RelatedI have a number of deliverables and want to create a graph for each one,
I can get a list of deliverable via a select statement but not sure how to create a graph from that
For example I have this sql statement as the row source for a graph
Code:SELECT Team.TeamLeadName AS Expr1, FormatPercent(Avg(RawData.PercentComplete)) AS CurrentProgressFROM Team, RawDataWHERE (((RawData.TeamLeadNumber)=[Team].[TeamLeadNumber]) AND ((RawData.DeliverableDesc)="RACE Off-the-runs v1"))GROUP BY Team.TeamLeadName;
"RACE Off-the-runs v1" is a deliverable
I had the idea of taking the list of deliverables and iterating through them, for each iteration set the row source for a graph as
Code:SELECT Team.TeamLeadName AS Expr1, FormatPercent(Avg(RawData.PercentComplete)) AS CurrentProgressFROM Team, RawDataWHERE (((RawData.TeamLeadNumber)=[Team].[TeamLeadNumber]) AND ((RawData.DeliverableDesc)="deliverableNAME"))GROUP BY Team.TeamLeadName; where deliverableNAME = the current deliverable in the iteration
The problem is
1)I’m not sure if/how to set the row source with a variable (in this case the variable is deliverableNAME)
2)How would I make sure that each iteration its creating a new graph, rather then just overwriting the existing one. Basically how to have each iteration create a new graph.
3)How would I store these graphs, each one on its own form, can they all be on one form (access seems to limit the height a form to 22 inches)
Hi all,
New user here so apologies if I post in the wrong place.
My colleague and I are trying to put together a database which automates a very time consuming process which is currently being done in Excel.
The purpose of the database is to pull together a load of actuals from SAP and then the forecasts we have put together and then chuck out a whole load of graphs and a summary spreadsheet/ report for the upper echelons;ons of management.
The data is in the database and so far it is all going well - but we have hit a stumbling block. We need Access to calculate some cumulative totals so that we can throw the whole lot into our excel graphs but we can't figure out how to do it.
We are using ye olde Access 97 so our options are a little limited.
Can anyone give us a starter for 10? If you need anything more technical, I can post whatever information you need.
Thanks
Tasha
My database records order details for analysis. I have created a form to monitor individual trends in orders placed by my customers. As we supply bespoke items each customer has a list of products which they alone purchase, i.e we do not supply stock items, each item is specifically for one customer (they can then buy the items on a regular basis). The products are assigned to a customer in the products table.
The Analysis form I have created displays the customers name and two graphs. The first graph shows total sales each month, this graph updates as I navigate through the records (i.e. a different graph is loaded for each customer). The form also contains another graph, this is where the problem lies! This graph shows orders of the individual products, controlled by a drop down list containing all the products we supply. I need to limit this list to only show those products relevant to the current customer select on the form. (The products are assigned to a customer in my products table). Currently I achieve this by using a query which when the form is opened asks me to enter a customer ID, the drop down list is then limited to the products supplied to that customer.
What I would like is for the drop down list to update as I navigate through the records. i.e. when customer A is displayed show all the products assigned to customer A, when customer B is displayed show all the products assigned to customer B.
I’ve attached a snapshot of the form to help explain what I mean.
Thanks for any suggestions.
i have a graph in access, and when i print it on a laserjet printer, all of the data and text prints. When i print the graph on a inkjet, only the text prints...not the graph. How do i solve this?
View 1 Replies View Relatedanyway you can add the values onto a graph
eg i have created a bar graph and on each bar would like the value shown on the top of it
Hello,
I am about to start a project where I must link an Access front-end database to an Oracle backend. I have about a year of Access development behind me now, and now here is the next challenge.
What I have to do is create analyses of data and output the data mainly in the form of diagrams (i.e. graphs or charts). I have seen how this can be done with Automation in Access in a book by Alison Balter (Mastering Access 2000 Development), by controlling the Excel object etc.
Here are my 2 questions:
1. I am considering buying another book on Access now, something that will contain more examples/methods for presenting information as a graph with the help of Excel. Should I stick to buying an Access book, or should I look into getting something that is more Excel programming oriented, i.e. something like an “Excel programmers compendium”? Any recommendations/tips to get me started would be appreciated.
2. The users want the graphs that I produce to be saved as a .PDF automatically at the push of a button in the Access GUI. How is this done? Do I need special software, or can I use something like PDFWriter to automatically convert the Excel graphs into .PDF’s?
Thanks in advance for the tips and have a nice day! :)
J
Using Access 2010 32-bit. I have a report that contains a Graph Chart (class = MSGraph.Chart.8). The reports works fine using the uncompiled .accdb. When I compile to .accde, the report is not rendered...I get an empty report screen as though Access is going to produce the report and nothing happens. I have to terminate Access using the "X" at the top right.
View 3 Replies View RelatedIs it possible to create a line or bar graph as a report in Access 2007?
If so, how would you go about it?
I am trying to change the chart type on a MSGraph control that I have added on my form. However, there is no graph.ChartType
OLE Class: Microsoft Graph Chart
Class: MSGraph.Chart.8
Hi all! I have a tough problem I was hoping I could get some help with:
I would like to create a recordset based on the "middle" 50% of the data. I need to chop 25% off the top of the data, AND 25% off the bottom of the data.
Any ideas?
I've got a label in a report which I'd like to have a bottom border only. Looking in the property sheet I don't seem to see this option (nor in the ribbon). Is there a way to do it other than with a line control? I'd like to have it attached to the actual border of the label . . .
View 1 Replies View RelatedI have a database with information on carriers, lanes, and prices.
I need to choose the cheapest 3 carriers for each lane.
The lanes are either 3-digit zip code to 3-digit zip code or state to state
(410-300 or CA-GA, etc.)
So for each of these lanes, I need to find the 3 cheapest carriers all
in one query.
So the resulting table should look like:
Lane Carrier Price
..........
TN-FL Schneider $50
TN-FL JB Hunt $66
TN-FL Dart $78
646-303 JB Hunt $77
etc.....
Except of course in columns :) Any ideas on how to do this? Thanks in advance!
In the tutorial whose link I have shown below: URL....The graphs that I create from the tutorial always have the legend on the right side. I would rather have the legend running along the bottom of the graph. I have two questions :
1. The graphs that I have already created, how can I get the legend to move down to the bottom of the graph? What command can I use?
2. When creating new graphs how do I make the legend go on the bottom of the graph and not the right side.
I have imported a table into a form and would like to know how to remove the navigation options from the bottom of the table, I know you can do it for the form but can you do it for a table contained in a form.
View 10 Replies View RelatedHi
I have created a query which sorts store information by potential opening dates...however, some of the stores are so new there are no potential opening dates as yet.
I would like the stores with blank opening dates to appear at the bottom but when sorting by ascending (which is what I need) these blank dates appear at the top... is there any way around this?
thanks
Ok, I have pesky solid line at the bottom of one field (bottom of the field with 6.80 in it..
I cannot figure out where it has come from or how to get rid of it!
Here's the properties for that particular field...
When I delete the column it appears somewhere else...
I have reports that total the figures in a column and displays the total at the bottom of the column. I would like to display the total at the top of the column since the length of the column continues to grow and I would like to see that total before scrolling down to view the various individual entries.
No matter how I try the =count(x) always shows an error. Is it not possible to display the total figure at the top of a column instead of at the bottom?