Query For A Chart?
Dec 6, 2007
I have a table called Projects
Each project has a Target Close Date
And some have an Actual Close Date
I want to create a chart that has months on the vertical axis (July to June)
and number of projects on the Horizontal axis
Then I want 2 lines on the chart showing how many projects were supposed to be completed and how many actually completed by each month. ie a running total
I think I need to make a query to get the data for this chart, but i dont know how...
View Replies
ADVERTISEMENT
Mar 22, 2006
Hi all,
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?
any assistance much appreciated.
thanks all.
regards
keji
View 1 Replies
View Related
Jun 28, 2015
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.
View 5 Replies
View Related
Aug 19, 2006
I'm currently using MS Access 2000 - When using the chart wizard is there any way of sorting the data by month ? At present I'm getting all my data on one chart but I want to spilt this into seperate months. (ie; 1 chart for July, 1 chart for Aug etc) I know there is the option for choosing 'between dates' but I don't want to have to do a fresh chart every time
Regards
Richard
View 1 Replies
View Related
Apr 4, 2006
Hey,I have a table with a date of birth field and I need to produce a pie chart showing age groups from this.The groups should be:< 16> 15 < 18> 17Help me!
View 1 Replies
View Related
Nov 20, 2007
I want to make a chart that shows the number of PLANNED CLOSE DATES and the number of ACTUAL CLOSE DATES for each month of the current financial year.
How do I make the Query to base this chart on?
Its been driving me crazy! :confused:
View 2 Replies
View Related
Jul 25, 2007
:) Hello,
Can anyone please tell me how to create a graphic (a chart like in excel) based on the result of a query? It's just names and values (2 fileds only)
Thankyou.
View 3 Replies
View Related
Jul 22, 2005
One of the requirements of my project is that a report should print a Bar Chart, based on a query.
The related query has the following fields:
ItemCode, Quantity_received, Quantity_delivered, and the Date.
The report should depict the number of transactions over a period of time, chosen by the user.
I have programming knowledge in Visual Basic, but quite beginner in MS Access VBA.
Any help please!
View 1 Replies
View Related
Jul 2, 2013
I don't seem to get it right to use a chart in my reports from a query.
See attached database. I want to create a chart in the report to give visual feedback to the user.
View 4 Replies
View Related
Oct 19, 2007
Wasen't sure whether this is a Reporting thing or a Querie thing as it resides inbetween the two.
Basically (and believe me I thought this would be pretty straight forward!!!!), I am trying to create a chart from a query that returns the occurences of concerns raised each month for a year. The query returns the following:
MthTextExpr1
Jan0
Feb0
Mar0
Apr1
May0
Jun0
Jul1
Aug1
Sep2
Oct1
Nov0
Dec0
In order that the user can specify a year that the chart will be applicable to, there is a field within the query that relies on the input of a year on an unbound text box on a form: [Forms]![frm_concern_frtpage]![Enter Year] is inputted into the critera box of this field.
However, if you try to create the chart it does not like this and just gives the following two error messages. If you enter a value into this text box and run the report containing the chart, it just gives a blank chart!!!!
Why is this error occuring?
I just want months along the X axis and the values from the Expr 1 column to be displayed on the Y axis!
View 5 Replies
View Related
Jul 1, 2013
I'd like to create the chart from the attached table.
But some part numbers don't have quantity in certain month.
So those month won't show up in the report as you can see from attached picture (May is missing).
is there a way to create the query so that it shows 0 for May?
I was going to use crosstab query but it won't work somehow.
View 1 Replies
View Related
Jul 3, 2014
I am trying to run simple query make a chart in report through this query but its not generating chart?
SELECT [Unsafe Act Unsafe Condition].[Inspection Audit], Count([Unsafe Act Unsafe Condition].[Inspection Audit]) AS [CountOfInspection Audit]
FROM [Unsafe Act Unsafe Condition]
WHERE ((([Unsafe Act Unsafe Condition].Date) Between [Forms]![frmSafetyReportOut]![startDate] And [Forms]![frmSafetyReportOut]![endDate])) OR ((([Unsafe Act Unsafe Condition].Department)=[Forms]![frmSafetyReportOut]![cboDepartment]))
GROUP BY [Unsafe Act Unsafe Condition].[Inspection Audit]
HAVING ((([Unsafe Act Unsafe Condition].[Inspection Audit]) Is Not Null) AND ((Count([Unsafe Act Unsafe Condition].[Inspection Audit])) Is Not Null));
View 1 Replies
View Related
Apr 8, 2014
I have some data that I want to display in a chart:
Code:
Theme Type Count(Type)
Blah1 1 5
Blah1 2 5
Blah1 3 8
Blah2 1 1
Blah3 2 5
Blah3 3 10
Blah4 1 111
Blah4 2 222
Blah4 3 333
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:
Code:
Theme Type1 Type2 Type3 Type4
Blah1 5 5 8 1
Blah2 1
Blah3 5 10
Blah4 111 222 333
Is that correct and does that make sense? If it isn't correct how else do I do it?
View 10 Replies
View Related
Mar 27, 2014
I have a status form which I use to show users the progress of various routines as they are performed. It's pretty basic; just a textbox and a couple of coloured labels; one for the outline ('things to be done') and one for the progress so far ('things done').
I have a function which I call periodically during the runtime of the routine which passes as arguments the text to display in the textbox (i.e. a description of which 'thing' is being worked on at that time) and two long integers representing what is 'done' and what is 'to be done' (i.e. 3 'things' done out of a total of 7)
So if I can divide a function into 7 distinguishable 'parts', I would call that function 7 times during the life of the overall process to show the updated status each time.
The function redraws the labels (i.e. sets the width of the 'done' label as a proportion of the width of the 'to be done' label, based on the ratio of the two arguments) and repaints the form. So you get a nice animated progress bar which can be easily controlled by calling the same function and just incrementing the 'done' argument each time.
Now - and admittedly this is purely aesthetic and for my own curiosity rather than anything fundamental - I was wondering if it were possible to represent this progress as a 3D pie chart rather than a horizontal bar (label)?
For no other reason than I think it would look really tidy.
I know it's possible to add a chart object to a form but the chart wizard insists I link the chart to a table or query. In this instance, I don't want to do that; I merely want to draw a very basic pie chart based on the two values passed as arguments to the status function.
View 3 Replies
View Related
Sep 17, 2014
So I have a code that opens a query but I want the PivotChart to show. Below is my code related to opening the query.
If vartyp = 0 Then
varQueryName = DLookup("Query", FileName, Criteria)
If IsNull(varQueryName) = False Then
DoCmd.OpenQuery varQueryName, acNormal
End If
View 1 Replies
View Related
Sep 7, 2014
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.
View 1 Replies
View Related
Dec 23, 2014
I am trying to use this query. It gives me correct results as query. However when I make chart with query on a report it doesn't show correct data and eventually stops making chart
SELECT qry.txtRC, Count(tbl.txtRC) AS CountOftxtRC
FROM tblMain AS tbl, qryRC AS qry
WHERE (((tbl.txtDepartment)=[Forms]![frmRC]![cboDepartment] Or [Forms]![frmRC]![cboDepartment] Is Null) AND ((tbl.txtZone)=[Forms]![frmRC]![cboZone] Or [Forms]![frmRC]![cboZone] Is Null) AND ((tbl.txtRC )=[qry].[atnRC ID]) AND ((tbl.date) Between [Forms]![frmRC]![startDate] And [Forms]![frmRC]![endDate]))
GROUP BY qry.txtRC , tbl.txtRC
HAVING (((Count(tbl.txtRC )) Is Not Null)) OR (((Count(tbl.txtRC )) Is Not Null))
ORDER BY Count(tbl.txtRC ) DESC;
View 1 Replies
View Related
Dec 12, 2014
I have a totals query that shows results in a chart. It takes a parameter to limit results, by a combobox in a form.
Parameter in the query includes the OR "*" expression, in case someone wants to get the results unfiltered.
The Combobox in the form, has an AfteUpdate event that opens the chart (form) every time its value changes, by the [DoCmd.OpenForm "ChartForm" , acNormal] expression.
I don't know how to make it open the ChartForm when no parameter is selected in the combobox.
View 13 Replies
View Related
Aug 12, 2015
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;
View 3 Replies
View Related
Sep 16, 2014
I have a form, a couple of comboboxes and text boxes on it. When these are filled out, the SQL of a query is changed using these parameters.
There are three subforms on the form, all pivot charts, all based on the query being changed.
The goal would be to update all three according to the user-given parameters.
Right now the subforms only update if I close and open the form, which is probably not the best solution, since it's too slow.
I've also tried to requery and refresh them, with no result.
Then I tried to overwrite the recordsource of the subforms with the same text that was originally there. This got them to refresh their data, but then all of the charts disappeared and had to be built again, so this is a no go too.
View 7 Replies
View Related
Mar 22, 2006
Hi all,
stuck on this, not sure if it can be resolved....
I have a parameter query for which the parameter is based on a form field entry (i wanted to avoid the dialog box popping up).
No problems with this....however, I want to create a chart based on the same query however, i get the following error message because it does not recognise the query parameter.
Error Message: The Microsoft Jet database engine does not recognise '[Forms]![frmChooseDTDate]!DateOccured' as a valid field name or expression.
Can this be resolved?
Help most appreciated!
regards to all
K
View 2 Replies
View Related
Oct 11, 2005
I have a stack bar chart that shows hours an event took including delays so its 3 stacked bars. I want to add a goal or target line to the chart but can't seem to keep the bars stack because I have to change the chart type. Any ideas ??
Jon
View 1 Replies
View Related
Jun 12, 2007
I have a report that is populating from one query. It takes data for a year and groups it by month with the lost time for that month. I am comparing 3 years data 20005, 2006, and 2007. I have set the chart up and it looks good except that my time for each month goes into the data area as a "CountOf" lost time and all months are therefore one. I want to show the lost time for each month. I have tried right clicking on the field in the data area and Autocalc is set to Count, but everything else is grayed out and unavailable. How can I change this setting to just display the value? Thanks in advance for the help.
View 1 Replies
View Related
Dec 5, 2005
I need some help with charts:
I know that the wizard wont allow me to put in more than six fields in the chart. Is there any way that I can get around this???
PivotChart: if i have a field named "Jan", when i put it in the pivot chart or table as a sum, it changes the name to Sum_Of_Jan. Is there any way that i can change this??
thank you.
View 1 Replies
View Related
Mar 27, 2006
I once saw in this forum a link to a table that had instructions for referencing forms, controls, subforms and all that good stuff depending on which form you are on. I have searched and searched and I can't retrace my steps to find it again. Could someone please point me to it?
Thanks.
-Dave
View 1 Replies
View Related
Oct 18, 2006
What field do I select from my table and where do I place them on the sample
graph in order to get a pie chart showing the correct information?
Details:
I'm trying to insert a chart into a report. Each page of the report is for
a different model name and then breaks down the model into parts:
REPORT:
Model 1
section a=25% section b=30% section c=45% ....
I would like a pie chart to represent the way each model is broken down (one
slice=section a, one slice=section b....)
Here is the table I'm trying to base the charts off of:
section a section b section c
Model 1 25 30 45
Model 2 ..................
View 1 Replies
View Related
