Hello All,
I have a database of various artist's average annual auction prices,
which I would like to graph. In some years there are no sales for an
artist, and therefore no data for that artist for that year, in the
table.
However in selecting the years to graph, I want to commence with the
current year and work back through the data until I reach a year with
no data, so that the graph covers an unbroken period.
For example in the table below, the period to be graphed would be 2000
to 2007, being the unbroken period working back from 2007, as there is
no data for 1999.
1996 $1,300
1998 $1,500
2000 $1,800
2001 $1,900
2002 $1,600
2003 $2,100
2004 $2,400
2005 $2,600
2006 $1,800
2007 $2,200
The length of the period to be graphed will vary from artist to
artist, but all will have a common starting point of the current year,
and work back from there.
Can this be accomplished with a SELECT statement? If not, any ideas as
to how it can be done?
Many thanks in advance,
John Furphy
0  1223  This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: SallyBenjamin |
last post by:
Hello..
Can anyone help me with this coding. Basically, it needs to have add
node, remove node, add edges , remove edges and display the graph
But.I have only succedded to add node, add and remove edge and also
display graph...
Can anyone plz help me to change this and add the nodes..
Thank u
|
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: TD |
last post by:
I have a report that has the MS Graph control on it. I have a query
setup for the control.
I have a form with 6 check boxes where the user can select which fields
they want to appear in the query and thus appear in the report graph.
I want to know the best approach to modify the query on the fly when
the report is run, based on which check boxes are checked.
I've new to using the MS Graph object and have noted that whatever
|
by: newbievn |
last post by:
The code below is from Microsoft MSDN example for DirectShow:
CODE
#include <dshow.h>
void main(void)
{
IGraphBuilder *pGraph = NULL;
IMediaControl *pControl = NULL;
|
by: savas_karaduman |
last post by:
I am trying to create graph report with using query results. Query
result show me `total quantities` for some related `category name`.
When i attempt to create a Chart Report with wizard by using my query,
program does not allow me to select `category name`. So, graphic that i
have with values of `total quantities` has no meaning.
Can we say that Access is not able to serve a good graph interface like
Excel?
Should I create this graph...
| | |
by: nsymiakakis |
last post by:
Hi All, First let me start by saying, I absolutely love this site. I have an access database that records are keyed in including a date field. i.e. 3/4/07, 3/20/07, 4/10/07,4/18/07, 5/4/07... and queried using a parameter query that asks for a Start and End date. i.e. 1/1/2007, 5/1/2007. These results are in the form of number Totals for that period.
This all works well. Now I have been asked to create a bar graph on a report that will show...
|
by: ConfusedMay |
last post by:
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...
|
by: victorporton |
last post by:
D.K. is traveling from City A to City B. He can stop at some designated spots only.
I am trying to use Dijkstra’s algorithm to determine the “spot-to-spot” path that will get D.K. from City A to the City B in the minimum amount of time.
The input in my program is an integer n and the 2D coordinates of n spots.
Some assumptions have been made about the physical layout of the problem:
1) All the spots are considered to be in a square of...
|
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: 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: 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: 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: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
