<

Bar Graphs in an Access Query

Posted on
6,427 Points
227 Views
2 Endorsements
Last Modified:
Experience Level: Beginner
7:08
crystal (strive4peace) - Microsoft MVP, Access
Love empowering people by teaching and helping them develop applications.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers.

Hopes this gives you ideas on visualizing your data in new ways ~

Video Steps

1. Create a calculated field in a query

2. Use Cint to convert to integer for the number of repititions

3. use ChrW(9600) for the Unicode upper half block character

4. use String to repeat a given character a number of times

5. Color the graph by setting the column Format to something like [Blue]@


   colors: Black, Blue, Green, Cyan, Red, Magenta, Yellow, or White
   @ signifies that the value is text
2
0 Comments

Featured Post

Learn Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

State of play: Databases ensure data integrity and relationship through both primary and foreign keys, and MS Access is no exception. Well, that's not completely true ... A primary key should not be null.  - No problem, the NOT NULL constrain…
A common question in the Access topic area is how to pass values between forms or reports.  These threads frequently evolve into a discussion on how to save values so they can be used throughout the application.  This article will discuss some of th…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month