View Full Version : Compare data from two different dates


dapfeifer
07-18-2008, 08:56 AM
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
07-18-2008, 09:27 AM
How is the data stored?

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

WayneRyan
07-18-2008, 09:58 AM
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
07-18-2008, 10:29 AM
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.