Use Triangles and Circles in an Access Query! (example: Compare Stock Price to Previous)
Channel: LearnAccessByCrystal
Date: 2017-07-09

Access Query - Triangles, Circles, Compare Previous Stock Price

Use Unicode characters in Access queries to display triangles and circles! Graphically indicate if values has increased, decreased, or stayed the same.

Compare values in previous records -- use two copies of the table and join with criteria.

Define a calcuated field that gets the difference of two records in the same table.

Create a field that shows a down-triangle, circle, or up-triangle depending on how a value relates to the previous value.

Correct for date format in other countries -- use ISO 8601 or force use of the American format.

Performance slow? convert domain aggregate function DMax to a subquery.

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

* 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