My table essentially revolves around two columns: Date and Revenue.
I would like to create a query that in addition to the two above mentioned columns, displays the previous days revenue (the previous record) and in a separate column displays the difference between yesterdays and todays revenue.
Any help would greatly be appreciated.