Help! chart

  • Thread starter Thread starter GR
  • Start date Start date
G

GR

Please I can't figure out how to solve this... maybe I
wasn't clear enough in last post. so I'll try to explain
it again.
I have a field for offers, each offers is valid during a
certain period defined in a beginning date and an ending
date.
How can a build a chart of offers versus validity period
in order to see offers overlapping?
Ex.

offer# Beginning date end date
101 12/05/2002 01/10/2003
102 08/07/2003 09/13/2003
103 10/01/2003 12/12/2003

And build the chart with this fields..

So the chart will look more or less like this:

offer#
¦
¦
¦
¦
¦
¦
103 ¦ xxxxxxxx
102 ¦ xxxx
101 ¦xxxx
¦_____________________________
Jan/03 Feb/03 ..... Dec/03

Hope someone can help..
gr
 
My suggestion is that you experiment in Excel first because Excel has very
good charting capabilities. Take some sample data and place it into an
Excel spreadsheet. Play with the data and the Excel charting functions.
When you get the chart to look like what you want then try to use Excel VBA
to automate the process. You would then use the Excel VBA code as a guide
to implementing a similar process inside Access. Alternatively, you could
export the Access data to Excel and have Excel produce the chart. Exporting
to and running Excel from within Access can be accomplished quite easily.
Let Excel produce the report.

Hope these ideas help.
Cheers,
Henry
Please I can't figure out how to solve this... maybe I
wasn't clear enough in last post. so I'll try to explain
it again.
I have a field for offers, each offers is valid during a
certain period defined in a beginning date and an ending
date.
How can a build a chart of offers versus validity period
in order to see offers overlapping?
Ex.

offer# Beginning date end date
101 12/05/2002 01/10/2003
102 08/07/2003 09/13/2003
103 10/01/2003 12/12/2003

And build the chart with this fields..

So the chart will look more or less like this:

offer#
¦
¦
¦
¦
¦
¦
103 ¦ xxxxxxxx
102 ¦ xxxx
101 ¦xxxx
¦_____________________________
Jan/03 Feb/03 ..... Dec/03

Hope someone can help..
gr
 
Back
Top