I want to display that query data in a Pie Chart, one chart for each theme with a section of pie for each Type (with the value of the count determining the size). Unfortunately my mind has gone blank. Everything I try does not appear correctly, some queries also require an repeated entry of the parameters but even if I do that it doesn't display correctly. I think I need to write another query to the format:
I created a table called weld_performance. it consist weld_id, weld_prod, total_rt, accepted, rejected, and rejection rate. from weld_prod until rejection rate, the type data is number. the rejection rate field size is Single, and Format is Percent.
Based on this table, i create a query called query1. and based on this query1, i create a chart. please see attachment pic001. as you can see the data label on the chart is showing 0.66667. but in my query1, the value is 67%. if i click the value (67%) it's change to 0.66667.
So I guess, the chart is read the 0.66667 value from the query. now what i want to ask is, how can my chart data label is shown 67% instead of 0.66667 ??
I Have this graph that needs to be run from a combo box selection. it doesnt seem to want to display any information at all. i have attached my database.
My problem is displaying data in many-to-many relationships.
There are three main tables: tblShops, tblOwners and tblMarketingEvents.
These are linked through two junction tables creating two many-to-many relationships:
1) Each Shop may have more than one Owner and each Owner may have more than one Shop. 2) Each Marketing Event may reach more than one Owner and each Owner may be reached by more than one Event.
Now I want to display for each Marketing Event:
1) the data of that event, (tblMarketingEvents) 2) plus the owners reached in that event, (tblOwners) 3) plus all the shops owned by the owners reached in that event. (tblShops)
Preferably, I want to display more than one record at a time without repeating any information.
Is there a way to display the data like this?
I tried a query: it gives the right data but does not display it as I need. It repeats the data from tblMarketingEvents and tblOwners for each shop.
I tried a form with subform: it can only display one record at a time and is hard to work with (printing etc)
I tried a report with grouping levels based on the query: Again, right information, wrong display. I need to group according to the records of the MarketingEvents table and not just according to a single field.
I was just wondering if I could use a query and table to create pivot chart? and If so how I could do this? I need information from both in order to create the chart I want.
I have a graph chart and my row source type is a Query. So I retrieved data from the Query that I built.
However , I want to get the data from the uploaded excel file.
I have a form that will prompt user in the beginning to upload the excel file and replaced the old table in Access- "CrossSystemData"
Basically , I want to pull data from Excel file , Run the query(Data from excel file) then excute to "display a chart based on my query" ... Is it possible ?
Query SQL: "PolyWrongRegInsCount"
Code: SELECT GROUPING.INSTITUTION, Count(*) AS NO_OF_GROUP FROM (SELECT DISTINCT CATEGORY, GROUP_NO, INSTITUTION, IIF(Left(INSTITUTION,1)="P","POLYCLINIC","HOSPITAL") AS INS_TYPE FROM CrossSystemData WHERE INSTITUTION NOT LIKE "*UNKNOWN*") AS GROUPING WHERE (((GROUPING.CATEGORY)="WRONG REG") AND ((GROUPING.INS_TYPE)="POLYCLINIC")) GROUP BY GROUPING.INSTITUTION;
My Chart SQL :
Code: SELECT PolyWrongRegInsCount.[INSTITUTION], PolyWrongRegInsCount.[NO_OF_GROUP] FROM PolyWrongRegInsCount;
Value 1 which is the number of working Employees and Value 2 which is the total number of Employees
Both are subject to change but my main problem is that Value 2 (Total of Employees) i want to display as 100% in a chart and Value 1 is the percentage of employees utilized.
I have the calculation working fine (Value 1/Value 2).
But if for example i have 35 employees as Value 2, how do i make that show as 100% in the chart?
I get things like 35 or 3500%?
I have played about endlessly changing values etc but just cant get it.
I am using 2013 access and i cannot find a chart details i.e. pivot or bar charts. Therefore I have exported the information into an excel . if there is no charts functions on this access .
Is it possible to export the information yet the pivot chart stays in the excel so i don't have to keep creating the charts information.
It work but the image only show only 2 or 3 images, other chart only show nothing. is there something that i missed ? How to export all these chart (9 chart) as image without corrupting ?
I have made a database where i plan the company's resources in form of hours. The idea is that every employee will put in their own data for the upcoming 4 weeks. I do this in a table where i store employeeID, weeknumber, year, PlanneHoursUsed, ActualHoursUsed.
This again i take into a pivot chart to see a forecast for the next month.
I have somehow achieved to get up a graph where i for every month can see the sum of all planned hours and all used hours (See attachment). BUT; my boss wants to see a running total instead of a "weekly image". On the graph attached one can see the numbers for every week. But i would want to see instead a running total.. For instance week1 then week2 would be the sum of 1 and 2, week 3 would be 1 ad 2 and 3 and so on. So the graph would be inclining throughout the year.
Is this possible with functions with my current data? Or do i need to have another field in my table where i store a running total? (This would be tricky when we get a lot of data and when somebody changes an old value...)
I try to develop an access 2010 Forms that contains 1 or 2 charts. So my problem is, in my form I have 1 combobox and 5 unbound textbox. Inside Event OnChange combobox, there is function DCount that will setup value to the 5 unbound textbox. Until this point, the 5 unbound textbox is have its value.
Now I would like to create a chart that value are based on the 5 unbound text. How can i accomplish this ? i see in many articles, a chart row source is link to a cross tab query.
after building a database in Access 2010, I am having a hard time with something that seems relatively simple.
I am trying to create a bar graph PivotChart with 2 different values associated an individual axis. While I can get the data into the PivotChart, I can't seem to make it stop overlaying the data. This is problematic because it causes one of the bars to be behind another.
Is there a way to make this data stack up side by side rather than on top of each other?
I've already tried changing the chart type, made the data separate groups, overlap is set to 0.
I'm trying to create a chart in a form, this is not a problem, however, the chart types available are a bit limited compared to if i inserted a Microsoft Excel Chart object.
I'd do that except I'm trying to create a chart based on a query.
Is there a way to make the chart wizard use the Microsoft Excel Chart object as its chart creator so I have access to the chart types available in that object?
I'm in the middle of doing a huge survey at work. The end resut will be a report which reflects the survey answers as graphs.
The graph part I have down. There will be one graph for each question. Within each graph are three groupings: Classified, Management, Certificated. Within the groupings you will see at least three bars where each bar represents a grouping of answers.
Example: the classified grouping may have 2 bars. One bar represents 16 classified people who said "Agree" to question 11 and the other bar represents 5 classified people who said "Disagree" to question 11.
...ok, so now I have all that, but I have to have data labels on the graph. I can do that, I know where to click, but unfortunately it comes up as the actual number of people who responded this particular way (agree, disagree, etc.) and I need the data label to show up as a percentage.
Where do I make the change so that it shows the percentage of 16 classified out of 21 who said "Agree"?
I am trying to publish an Excel Pivot Chart, but keep getting Run Time Error 1004 - Application-defined or object-defined error...
I have tried the code 2 ways:
Code: Sub PublishChart() Worksheets("Historical_Pivot").Activate With ActiveWorkbook.PublishObjects.Add(xlSourceChart, _ Path & "" & "AWA" & "_" & "JAMALCO" & "_" & "Chart" & ".htm", _ "Historical_Pivot", "JAMALCO", xlHtmlStatic, "ABC REQ BACKLOG_2013", "") .Publish (True) .AutoRepublish = False End With End Sub
Code: Sub PublishChart() Dim wb As Workbook Dim ws As Worksheet Set wb = ThisWorkbookSet ws = wb.Sheets("Historical_Pivot") ws.ChartObjects("JAMALCO").Activate With wb.PublishObjects.Add(xlSourceChart, Path & "" & "AWA" & "_" & "JAMALCO" & "_" & "Chart" & ".htm", ws _ , "", xlHtmlStatic, "", "") .Publish (True) End With End Sub
I have a form with a chart , 2 textboxes for start date and end date and a button to filter the data( filter the data by date range) How do i continue from that? The chart isnt updating.
I am working on a project that is requiring me to hide a subreport that happens to be chart graph, when the chart has no data and my problem is that I cannot seem to get the report to properly hide and show the label behind it when the data is not there. I am in need of a SQL code that will read my blank record source as a zero instead of blank. I have tried Nz, IsEmpty, and IsNull and none of them seem to work.Here is the current SQL code:
SELECT DISTINCTROW Sum(Case_review.ID) AS SumOfID FROM Case_review WHERE (((Case_review.[Type of Issue].Value)="Clinical"));
Here is the current VBA code (which is in event on load) for the main report:
If Me.Rpt_Clinical.Report.HasData = -1 Then Me.Label29.Visible = False Me.Rpt_Clinical.Visible = True Else Me.Label29.Visible = True Me.Rpt_Clinical.Visible = False
I have a table which has a yes/no field, in the table everything displays as either Yes or No, unless you click on it to edit it, whereby No become 0 and Yes becomes -1.This isn't a big problem as users can only access forms. On the input form this is a check box, checked for Yes and unchecked for No. This used to be a drop down selection box of Yes and No and the same problem was occuring, so I know the problem doesn't relate to the check box.
I have a second reporting form which has multiple combo boxes to filter down results in a subform. In the subform the field correctly displays as Yes and No, however, the filtering combobox for this field has the options 0 and -1.
The combobox is set up as Yes/No, the table is Yes/No and the results are Yes/No. There is no other formatting or input options that can be changed to tell the database this is a Yes/No field.How can I get this combobox to display as Yes/No? It's causing a lot of confusion with users as they are having to select 0 or -1.As a note, I've already tried the following:
-Deleting the combobox and starting again. -Deleting the table and combo box and starting again. -Deleting all tables, queries and forms which use this field and starting again.
None have worked, this seems to be something Access is doing rather than an error in what I've done.The filter form uses this code, which may be the cause:
Code: Option Compare Database Option Explicit Private m_colCombos As Collection Private m_strFilter As String
Colm and Baxter, you've been great helps to me so far, and I will include you in the special thanks in my programming credits. I ask your help once more-
My program tracks how many calls are received per day at the office. I have a report showing a chart (thank goodness for wizards ) that lists the calls per day. This all works fine, and I was extremely proud of myself for doing so. However, after thinking about it, I realized that after a while, my client might not care to see ALL of the calls per day ALL of the time, and might wish to see maybe a week's worth or a month's worth at a time. I was thinking I could solve this by using a form to enter "from" and "to" information, but I'm not quite sure how to apply this so it would work with my report.
Also, if I can get this to work, on this same form I would like to have an option field that the user can select so that the usual options (today, this week, this month, this year, all) require only a click, rather than having to figure out what days are in this week (a tedious task, I know, but we're going for efficiency here ) but they also have the option of seeing specific dates they want.
The fields that I'm using for this are very simple- tblCustomer.CallDate and tblCustomer.LeadType, where CallDate is just a date and LeadType is a string from a lookup table that is either "Call-in" (the one I'm tracking) or "In-field".
I know this sounds like a lot of coding, but I'm sure if you could get me started, I could figure out the rest myself. It's just that the way Access does dates is so confusing to me, and I have midterms coming up and not a lot of time to figure this out by myself from scratch. Anyways, thanks for your help in advance!
I have a chart in a form which gets its data from a cross-tab query. The chart was working fine and still is besides the fact the it is skipping the first row of data, or reading/treating it as a header. I had this problem before and the only way i could get around it was to re-create the charts. As there are many charts i want to avoid doing this again and find out why this is happening to prevent it happening again.
I have a number of charts that correspond to form fields. Once the fields are filled out and the form is saved I want the data automatically to update in the chart. I tried inserting a button to allow the user to manually do it, but it says that it is unavailable. The charts update when i click refresh, however I dont want the user to have to do this.
I a a new user to Access having only every ceate a couple of small databases using the wizards. I have just started a database where I have created my tables and I am now creating a form to display information. The problem that I am having is that when in Design mode I can see all the information and fields that I have used to create the form, however when i save the form then opening in display mode I do not see any of the fields, revert back to design mode and hey are all there.
