J
Jason Sizemore
Can I store the values calculated in a query back into
another table?
How can I calculate the difference between two values
from the same field but drawn from two different dates,
for example:
Date Value Difference
08/27/2003 1000
08/28/2003 1200 200
I would like to calculate this in a query and then store
it in a table. But I need to know how to reference the
value (ie 1000) from a previous date.
Thanks
another table?
How can I calculate the difference between two values
from the same field but drawn from two different dates,
for example:
Date Value Difference
08/27/2003 1000
08/28/2003 1200 200
I would like to calculate this in a query and then store
it in a table. But I need to know how to reference the
value (ie 1000) from a previous date.
Thanks