Compare data from two different dates (1 Viewer)

[dapfeifer]

Hey all,

I'd like to be able to compare data entered on two different dates (such as data from 6/4/08 and 7/3/08). I've kicked around a few things but can't seem to find a way to accomplish this. Any suggestions toward accomplishing this would be appreciated!

The comparisons probably need to be done in VBA and the difference displayed in a form or report.

 

[Alc]

How is the data stored?

What sort of comparison(s) are you hoping to run?

 

[WayneRyan]

dap,

This might help:

http://www.access-programmers.co.uk/forums/showthread.php?t=127628

It was just an experiment, but should give you a start or some ideas.

Wayne

 

[dapfeifer]

The data would be pulled from a query which gets its data from another table in the database.

I don't know if comparison was quite the right word to use for this...I guess I'm more looking to find the difference between two dates and display that in a report. For example, say on 6/4/2008 there were 600,000 bytes sent, and on 7/3/2008 there were 550,000 bytes sent. I'd like to be able to find the difference (-50,000) and display that in a report.