Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access thread: graphics in database


Message #1 by "Richard Thurman" <thurman@c...> on Mon, 28 Oct 2002 17:02:48
Good Morning.
Is there a method to place a bar graph on a continuous form for each 
record that shows.
I have a form showing users and withdrawals by user. I show total 
withdrawals, mean withdrawal, and standard deviation fields with the 
intent of reporting any user exceeding the mean by one standard deviation. 
The usual chart object takes too much space and can't be used on 
continuous forms. The format I would like as follows:
 user      #withdraws     display
user1        5            .....
user2        3            ...
user3        22           ......................

total=30  ave = 10  std = 10.44
As the withdrawals could be in the thousands, I would use a fraction to 
display those relative quantities.  Seems simple enough, but nothing seems 
simple in Access graphics. Would export to Excel be easier?
Thanks.
Rick
Message #2 by "Richard Thurman" <thurman@c...> on Tue, 29 Oct 2002 14:40:48
Please disregard. Actually simpler than I thought. Just placed a textbox 
on form.  Rick  

  Return to Index