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

Sign in to queue

Description

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
https://channel9.msdn.com/Blogs/MVP-Office-Dev/Show-Bar-Graphs-in-Access-Query-using-Unicode-characters

~~~

Unicode:

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

 

Embed

Download

Download this episode

Download captions

The Discussion

  • User profile image
    Villadi1

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

  • User profile image
    Villadi1

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

  • User profile image
    strive4peace

    @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.

     

Add Your 2 Cents