Show Bar Graphs in an Access Query! ... using Unicode

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