T
tekari
Hi All,
I have a table that is setup like:
Date $'s
01/01/07 100.00
01/02/07 200.00
01/03/07 250.00
01/04/07 400.00
Is there a function in access or a module I can write that will give
the actual increase in a third column?
For example 1/1/07 should be 100.00 because thats the first entry.
1/2/07 should also be 100.00 because it's the difference between 1/1
and 1/2.
1/3 should show 50.00 as it's the difference between 1/3 and 1/2
etc...
I could do this easily in excel but I can't figure out a way in access
yet.
Thanks for any help!
I have a table that is setup like:
Date $'s
01/01/07 100.00
01/02/07 200.00
01/03/07 250.00
01/04/07 400.00
Is there a function in access or a module I can write that will give
the actual increase in a third column?
For example 1/1/07 should be 100.00 because thats the first entry.
1/2/07 should also be 100.00 because it's the difference between 1/1
and 1/2.
1/3 should show 50.00 as it's the difference between 1/3 and 1/2
etc...
I could do this easily in excel but I can't figure out a way in access
yet.
Thanks for any help!