Triangles! and Circles! in a Microsoft Access Query -- Get Previous Record too

Play Triangles! and Circles! in a Microsoft Access Query -- Get Previous Record too


Show triangles and circles in Access queries using Unicode characters. Graphically indicate if values have increased, decreased, or stayed the same. The data is MSFT closing price from Nasdaq's historical stock prices

How can you compare a value with the previous value in another record and calculate the difference in a query? And then show triangles and circles indicating up, down, or same ... and stagger them for greater grasp? 

This lesson also covers how to handle non-American date formats. 

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


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

Show Bar Graphs in Access Query using Unicode characters



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.

If you cannot show the Unicode characters used to demonstrate, try these instead:

filled circle  --> 9679

down-pointing triangle --> 9660

up-pointing triangle --> 9650



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




Download this episode

Download captions

The Discussion

  • User profile image

    Quick and easy. Try doing it with Excel; you'd need to couple it with Power Pivot, Power Query, Power BI...

  • User profile image

    At 4:20 you say, "There will not be a record for every day". Why do you say that?

  • User profile image

    @Villadi1: thank you for commenting

    >> "There will not be a record for every day". Why do you say that? <<

    Good question, thanks for asking.

    If there was consistently a record for everyday, then a query could be made to calculate the previous date by subtracting one from the date.  That query could then be used so a join line went from date to previous date, or the ON clause in the SQL modified without needing the intermediate query, and it would be relatively fast.

    In this case, the previous date is not known -- so criteria is used to join records instead of linking field lists.


  • User profile image

    Excellent tutorial and a very clever design. It is simple and straight forward. It can't get much easier than this to see at a glance the direction the price is going. Well done!!

Conversation locked

This conversation has been locked by the site admins. No new comments can be made.