<

Improve company productivity with a Business Account.Sign Up

x

Bar Graphs in an Access Query

Posted on
6,403 Points
203 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
Comment
0 Comments

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Join & Write a Comment

Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Implementing simple internal controls in the Microsoft Access application.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month