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