Compare records

[WKRJ]

How do you compare one record to the previous record? I have a query that shows items sold. It is sorted by day with today on top. I would like to create a column that has a 'thumb up' or 'thumb down" if todays was a better day than yesterday.

Thank you!
WKRJ

 

[Uncle Gizmo]

Look at this Example from Rogers access library...

http://www.rogersaccesslibrary.com/forum/topic279.html