heeeeeelp with 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
 
You can check the calendar reports download available at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4. There is a sample
report in the file that looks like what you want.

--
Duane Hookom
MS Access MVP


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