Show Bar Graphs in Access Query using Unicode characters

Sign in to queue

Description

Did you know that you can show a bar graph in an Access query? It is easy using a simple formula to show Unicode block characters. 

Use the built-in functions String  and ChrW (variation of Chr) to display a graph by repeating a Unicode character a calculated (or specified) number of times -- and this is all text!

Graphs appear on every record in the color you want ... give life to numbers.  Hopes this enables you ideas to visualize your data in new ways ~

this video shows another example of using Unicode in a query:

Triangles! and Circles! in a Microsoft Access Query -- Get Previous Record too
https://channel9.msdn.com/Blogs/MVP-Office-Dev/Triangles-and-Circles-in-a-Microsoft-Access-Query-Get-Previous-Record-too

Note: Some fonts have more, and better, Unicode representations than others. For Windows standard built-in fonts, Arial Unicode MS and Lucida Sans Unicode have fair coverage.  Common fonts such as Arial, times New Roman, and Calibri can be okay too.

please Subscribe, Like, Comment, and Share ~ thank you

 

 

Embed

Download

Download this episode

Download captions

The Discussion

Add Your 2 Cents