Bar Graphs in an Access Query

Posted on
6,439 Points
2 Endorsements
Last Modified:
Experience Level: Beginner
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
Provides a one size fits all solution for File Dialog calls for all MS office applications. Module contains function fncGetFilePathTRM() which does all the filter building for you. I've used a similar version of this for over 15 years, 1 module impo…
Windows Explorer lets you open archive (tar and tgz) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating archive files takes a little more - and that you'll find here.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month