I would like to create a querie or report that shows today's volume and yesterday's volume side by side. Ex.

Date Volume Yest. Volume
1/1/10 58 45
1/2/10 65 58
1/3/10 55 65
1/4/10 70 55

This will come from a table that gives you the date and volume.

One way, though with a lot of records it can be slow:

http://www.baldyweb.com/PrevValue.htm