Hi,
I need to create a graph report that showed total hours and unattended hours based on certain months and operation code that user input into the form.
I have two queries:
one to calculate the total hours worked and the other is to calculate total unattended hours. I also have a form, where user input what months and what operation code that user wants to see on the graph.
now I need the graph to show on the primary axis is the total from total hours query and on the secondary axis is total from unattended hours query.
I can't combine the 2 queries together since it gave me duplicated total and unattended hours (that's why I have to seperate the query into 2). can we use two queries on the graph? Could you help me what is the best way to do this report? This is the first time I'm using graph.
Thank you
3  1793  ADezii 8,834
Recognized Expert Expert
Hi,
I need to create a graph report that showed total hours and unattended hours based on certain months and operation code that user input into the form.
I have two queries:
one to calculate the total hours worked and the other is to calculate total unattended hours. I also have a form, where user input what months and what operation code that user wants to see on the graph.
now I need the graph to show on the primary axis is the total from total hours query and on the secondary axis is total from unattended hours query.
I can't combine the 2 queries together since it gave me duplicated total and unattended hours (that's why I have to seperate the query into 2). can we use two queries on the graph? Could you help me what is the best way to do this report? This is the first time I'm using graph.
Thank you
Post the SQL from the 2 Queries. How are the values for Month and Operation transferred to the 2 Queries?
Post the SQL from the 2 Queries. How are the values for Month and Operation transferred to the 2 Queries?
I have a form called selection that has 3 textboxes which are txtstartdate, txtenddate, and txtopcode for user to input the information.
here is the query to calculate the total hours: (I create regular query, but here is the SQL view):
SELECT labor_ticket.DA TE, Sum(labor_ticke t.HOURS_WORKED) AS SumOfHOURS_WORK ED, Opcode.Departme nt, Opcode.Opcode, (Format([DATE],"mm"" '""yy")) AS months_total
FROM LABOR_TICKET INNER JOIN Opcode ON LABOR_TICKET.RE SOURCE_ID = Opcode.Opcode
GROUP BY LABOR_TICKET.DA TE, Opcode.Departme nt, Opcode.Opcode, (Format([DATE],"mm"" '""yy"))
HAVING (((LABOR_TICKET .DATE) Between ([forms]![selection]![Txtstartdate]) And ([forms]![selection]![Txtend])) AND ((Opcode.Opcode )=[([forms]![selection]![Txtopcode]))
ORDER BY LABOR_TICKET.DA TE, Opcode.Departme nt;
and here is the query to calculate the total unattended hours:
SELECT LABOR_TICKET.DA TE , Sum(LABOR_TICKE T.HOURS_WORKED) AS Unattended, Opcode.Departme nt, Opcode.Opcode,( Format([DATE],"mm"" '""yy")) AS months_unattend ed
FROM LABOR_TICKET INNER JOIN Opcode ON LABOR_TICKET.RE SOURCE_ID = Opcode.Opcode
WHERE (((LABOR_TICKET .EMPLOYEE_ID) Like "8*"))
GROUP BY LABOR_TICKET.DA TE, Opcode.Departme nt, Opcode.Opcode, (Format([DATE],"mm"" '""yy"))
HAVING (((LABOR_TICKET .DATE) Between ([forms]![selection]![Txtstartdate]) And ([forms]![selection]![Txtend])) AND ((Opcode.Opcode )=[([forms]![selection]![Txtopcode]))
ORDER BY LABOR_TICKET.DA TE, Opcode.Departme nt;
what I need is to create a chart report that consists total hours and total unattended hours values. could we use 2 queries in the chart report? Please help.
Thank you so much
I have a form called selection that has 3 textboxes which are txtstartdate, txtenddate, and txtopcode for user to input the information.
here is the query to calculate the total hours: (I create regular query, but here is the SQL view):
SELECT labor_ticket.DA TE, Sum(labor_ticke t.HOURS_WORKED) AS SumOfHOURS_WORK ED, Opcode.Departme nt, Opcode.Opcode, (Format([DATE],"mm"" '""yy")) AS months_total
FROM LABOR_TICKET INNER JOIN Opcode ON LABOR_TICKET.RE SOURCE_ID = Opcode.Opcode
GROUP BY LABOR_TICKET.DA TE, Opcode.Departme nt, Opcode.Opcode, (Format([DATE],"mm"" '""yy"))
HAVING (((LABOR_TICKET .DATE) Between ([forms]![selection]![Txtstartdate]) And ([forms]![selection]![Txtend])) AND ((Opcode.Opcode )=[([forms]![selection]![Txtopcode]))
ORDER BY LABOR_TICKET.DA TE, Opcode.Departme nt;
and here is the query to calculate the total unattended hours:
SELECT LABOR_TICKET.DA TE , Sum(LABOR_TICKE T.HOURS_WORKED) AS Unattended, Opcode.Departme nt, Opcode.Opcode,( Format([DATE],"mm"" '""yy")) AS months_unattend ed
FROM LABOR_TICKET INNER JOIN Opcode ON LABOR_TICKET.RE SOURCE_ID = Opcode.Opcode
WHERE (((LABOR_TICKET .EMPLOYEE_ID) Like "8*"))
GROUP BY LABOR_TICKET.DA TE, Opcode.Departme nt, Opcode.Opcode, (Format([DATE],"mm"" '""yy"))
HAVING (((LABOR_TICKET .DATE) Between ([forms]![selection]![Txtstartdate]) And ([forms]![selection]![Txtend])) AND ((Opcode.Opcode )=[([forms]![selection]![Txtopcode]))
ORDER BY LABOR_TICKET.DA TE, Opcode.Departme nt;
what I need is to create a chart report that consists total hours and total unattended hours values. could we use 2 queries in the chart report? Please help.
Thank you so much
never mind I got it... Thank you....
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Herman |
last post by:
Hi everyone, I'm implementing Dijkstra's algorithm for a class
project, and I'm having trouble compiling the class that runs the
algorithm. All of the other files compile fine except for this one.
I am using the compiler like this:
javac -classpath .. <filename.java>
The source code of the classes follow. Dijkstra.java is the class
that won't compile, because the compiler doesn't recgonise the Vertex
and GraphMap classes, even...
|
by: SS KANAGAL |
last post by:
Hello,
I am drawing a bar graph in an aspx page using
System.Drawing namespace .
Now I want to provide drill down facility for the graph
i.e. on click of a bar in the graph it should get me yet
another graph with different data populated in that graph.
I want to know how to provide href for each bar in the
graph in the code behind.
|
by: mark.engelberg |
last post by:
I am having trouble identifying the source of a memory leak in a
Windows Python program. The basic gist is as follows:
1. Generate a directed graph (approx. 1000 nodes).
2. Write the graph to a file.
3. Use the os.system command to invoke another program which processes
the graph file (graphViz), and generates a gif image of the graph.
4. Use another os.system command to delete the intermediate file, which
is no longer needed.
5. Append...
|
by: Jeff Blee |
last post by:
I am hoping someone can help me. I am making a Access 97 app for a
person and have run up against a problem to do with MS Graph. There is
a table that has a number of data elements and a date field and
entries are entered each month.
A graph is required that has three of the data elements represented
basically on the y axis and time as months along the x axis. So for
each month there is a group of three columns representing the data...
|
by: entropy123 |
last post by:
Hey all,
In an effort to solve a sticky - for me - problem I've picked up
Sedgewick's 'Algorithm's in C'. I've tried working through the first
few problems but am a little stumped when he refers to #include
"Graph.h" in the header file of the first program.
The style he uses to make his declarations is a little unfamiliar to
me, but here is my best guess at a "Graph.h" header file:
| | |
by: Bigs |
last post by:
Ok, I have been working on a Linear Equation program that will draw a line on my graph. But, I am not sure how to set up the y=mx+b in Java to return the (x1,y1) and (x2, y2) using only the slope and y-intercept.
Can anyone tell me how to set up the linear equation in java.
if (Global.psize == 1)//Check If Line Should Be Graphed
{
Global.slope = x1i2;
Global.yinter = y1i2;
Global.yinter = Global.y1i1;// b=y For First Point On y Axis....
|
by: huiling25 |
last post by:
I was given the pseudo code.. but i still cannot figure out how to do it... how can i find if the vertices are adjacent to the vertex on stack top? I know i have to have an array of true/false (to dictate if the vertex is being visited)...
dfs(v)
{ create a stack s to store visited notes
s.push(v)
while(!s.isEmpty())
{
if(no unvisited vertices are adjacent to the vertex on stack top)
{
//need a...
|
by: sriniwas |
last post by:
Hi Frnd's,
m using prefuse visulation,it's have one display class and this class have one saveImage(outPutStream, String jpg,double size);. now graph is converting ia jpg image properly.now my problem is tht,If graph is to large if it going out of screen thn ,i m getting jpg image on screen disply graph,m not getting the image of tht graph which going out of screen. this is my code
This is my code
|
by: thatos |
last post by:
Here is the EdgeList class
class Graph {
protected int numvertices;
protected int numedges;
protected boolean directed;
protected EdgeList adjlist ;
// Constructors
|
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: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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: 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...
| |
