View Single Post
  #12  
Old November 12th, 2009, 02:01 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 1,555
Default how to handle meter readings

If you do that "simple calculation" in a query, great! Don't bother trying
to add that value into a field in a table...

And if, by "input the peak and offpeak", you mean manually do the
data-entry, are you sure you can't just load it from the spreadsheet (no
re-typing required)?

--

Regards

Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned in
this post. Mention and/or description of a product or service herein does
not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"deb" wrote in message
...
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]
.