Let say, I have a table called USERS with the following fields:
UserID, Date, Name, ComType.
ComType gets it's info from another table called TYPE with fields:
TypeID, TypeOfCom, with options: Email, Phone, Message
Table Samples:
UserID Date Name ComType
-------------------------------------------
1 1/10 Paul Email
2 1/10 Liza Phone
3 1/10 Monet Email
4 1/15 Louie Message
5 1/15 Vin Phone
6 1/16 Dave Email
7 1/16 Chip Email
8 1/16 Danny Email
I have a form that asks user to enter a date range (i.e. BeginDate,
EndDate).
This form brings up a report like the one below:
Date No. Users Email Phone Message
-------------------------------------------------
1/10 3 2 1 0
1/15 2 0 1 1
1/16 3 3 0 0
How can I create a chart based on this report. Basically,
a form that asks for the date-range. A user enters a starting date
and ending date, and brings up the chart after hitting enter.
The chart will have the following chgaracteristics:
Date on the X-axis, No. of users on the Y-axis. There will
be 3 bars or legends: Email, Phone, Message. In other words,
each of the dates: 1/10, 1/15, 1/16 will have three bars.
One bar for "Email", one bar for "Phone" and one bar for "Message".
Any help or tips will be greatly appreciated. I was playing around
by creating the chart on a form. I was able to change x-axis but,
couldn't seem to add the 3 bars. Also, I don't know how I can
link the chart to a form for the date-range (like a filter). I
was able to change the legends but, everytime I ran it, it goes
back to "ComType".
You mail email me directly at "pc*******@yahoo.com". Thank you
very much in advance.
