<

Bar Graphs in an Access Query

Posted on
6,428 Points
228 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
0 Comments
Are you ready for a Linked Table Manager (LTM): - with a sizable form - which identifies which connections are valid and how many tables are associated with the connection - which doesn't ask you to select the BE multiple times when you've ident…
Do you need a date time picker, how about just a time picker?  Would you like to use something other than the basic Access date picker which is available when you have a textbox which contains data formatted as a date? Give this date time picker a t…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month