468,272 Members | 2,020 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,272 developers. It's quick & easy.

help in craeting a chart in access 2000

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.
Nov 13 '05 #1
1 1468
Paul,
If all you want to make is a histogram, its quite easy. I do it
all the time by using labels as the bars, right on the form. Set the
length of the bars based on the values in your table. You will need
to be familiar with scalers to convert table values to the physical
size of the label on the form. If you need more help, write me
direct.
Hank Reed
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by PDR | last post: by
reply views Thread by Bruce D | last post: by
8 posts views Thread by dkelly | last post: by
reply views Thread by rdemyan via AccessMonster.com | last post: by
reply views Thread by zattat | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.