C
Crazy Lady
Hi there, I said I'd be back.
What I have are records with a starting value, an on-going value and a final
value (the values being chargeable costs).
There are only 5 tables, several queries, forms and reports.
I have queries and forms showing the total cost as of the current date, and
I have queries and reports showing the total at a user-defined date.
However, as the values are changing on a day to day basis, I need to be able
to save records showing values to specific dates, then deduct that value
from the total leaving a balance (which may or may not continue to increment
daily). The fields would be something like "Total to Date", "Previous" and
"Balance"
What I have are records with a starting value, an on-going value and a final
value (the values being chargeable costs).
There are only 5 tables, several queries, forms and reports.
I have queries and forms showing the total cost as of the current date, and
I have queries and reports showing the total at a user-defined date.
However, as the values are changing on a day to day basis, I need to be able
to save records showing values to specific dates, then deduct that value
from the total leaving a balance (which may or may not continue to increment
daily). The fields would be something like "Total to Date", "Previous" and
"Balance"