fuel system Tank management for emergency generators

[SEALEGGS]

I have two questions. Does anyone have a template for managing fuel system tank management for emergency generators with a rolling 12 month calander?
In a table how to: update today’s record [Previous Ending Inventory] field with yesterday [End inventory total]?

 

[SEALEGGS]

Best way to return prior day end totals inventory data and update todays records?

 

[plog]

1. No.
2. You don't store redundant data--you retrieve it when you need it.

The way to do #2 is to create a query, determine the prior day's date, then link that query to the table via that calculated date and retrieve the values you need.