G
G. Weiler
Given fields: (CustomerID) as text, (MeterReading) as number, (ReadDate) as date type.
Anyone know how to fill in a new field, getting data from last-month’s Customer (MeterReading) and moving to this month’s (PreviousMeter), thus being able to calculate (Usage)? Am presently using Excel to do this, but I would rather not copy & paste if I can get around it, keeping all actions in Access.
Possible Complications :
ï‚· Due to changing out old meters and replacing with a new one, or the present meter “turning overâ€, there may be multiple (CustomerID) records in any given month.
ï‚· This is not only for a monthly billing report, but also for a month-by-month annual report summary.
Anyone know how to fill in a new field, getting data from last-month’s Customer (MeterReading) and moving to this month’s (PreviousMeter), thus being able to calculate (Usage)? Am presently using Excel to do this, but I would rather not copy & paste if I can get around it, keeping all actions in Access.
Possible Complications :
ï‚· Due to changing out old meters and replacing with a new one, or the present meter “turning overâ€, there may be multiple (CustomerID) records in any given month.
ï‚· This is not only for a monthly billing report, but also for a month-by-month annual report summary.