Show Bar Graphs in an Access Query! ... using Unicode
Channel: LearnAccessByCrystal
Date: 2017-06-18

Create a query in Microsoft Access that shows data as a bar graph. Combining the built-in functions String  and ChrW (variation of Chr),  you can display a graph by repeating a Unicode character a calculated number of times -- and this is all text!

In the Expression Builder, Intellisense helps as you type. Press TAB to select highlighted choice.

To best-fit a column, double-click on the right order, just like in Excel.

The final equation is: 
TheGraph: String( CInt( MyData.MyValue ) , ChrW(9600) ) 

CInt rounds an expression to a whole number.
String function repeats a specified character a number of times.
ChrW is a 'wide' variation of Chr to show a symbol for a Unicode character.

Calculated field names are typed in the beginning of a value in the Field cell of the Query Design grid. A colon (:) signifies the end of the Name.

Add color by setting the Format property to [color]@ where color is Black, Blue, Green, Cyan, Red, Magenta, Yellow, or White, and @ signifies that the value is text.

Access Defaults: To see windows that you can move and resize, instead of tabs, choose:
File, Options, Current Database, and thenset the Document Window Options to Overlapping Windows.

Resize columns in the query design. Launch the Expression Builder. Intellisense jumps in and helps.

Article: 
http://sfmagazine.com/post-entry/july-2017-access-graphs-in-a-query-using-unicode/

above, all ... have fun with Access!
enjoy greater heights of productivity

* let's connect *
Do you need help? You know your business. I know how to teach, write programs, and develop applications. If you have a budget and want control of your project, let's connect and build it together!

visit MsAccessGurus and contact me today!
http://msaccessgurus.com 

I look forward to hearing from you ~

have an awesome day,
crystal