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