peak, offpeak and total are simply going to be supplied to us as figures,
monthly in a spreadsheet - so i think i'll just input the peak and offpeak
and then do the total as a simple calculation
--
deb


"John W. Vinson" wrote:

On Tue, 10 Nov 2009 23:14:05 -0800, deb wrote:

dammit now i've been told i have to have peak, offpeak and total for the
meter readings for each meter

how do i do this without creating a separate tbl for each meter?

Two tables are all that are needed: Meters (one row per meter, with a unique
ID, its location, maybe information about the owner or what it's metering) and
Readings (ReadingID autonumber primary key, MeterID, ReadingDate (Date/Time),
Reading).

Peak, offpeak and total would be calculated dynamically in Queries based on
the Readings table; just how I don't know since I have no idea how often there
are readings, or how you distinguish peak from offpeak.
--

John W. Vinson [MVP]
.