View Single Post
  #19  
Old November 13th, 2009, 08:27 AM posted to microsoft.public.access.tablesdbdesign
deb
external usenet poster
 
Posts: 898
Default how to handle meter readings

LOL! i managed to convince him to use access even though he didnt know much
about it, no that he's discovered how useful its going to be he's like a kid
with a new toy.

keep in mind, this is a company with a multimillion dollar turnover, dozens
of buildings and hundreds of tenants running on spreadsheets......
--
deb


"Jeff Boyce" wrote:

As you've no doubt found, "easy ... is HARD!"

Making a user interface that users find simple and easy is not an
insignificant task.

It sounds a little like the person directing you isn't clear on what he
wants!

--

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
...
"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)? "

i did suggest that but he wants an input form as well, so the figures can
be
input manually from the electricity bills if necessary.

me, i'd just import from a spreadsheet each month and save the time, but i
think he's worried the person doing it will be an office junior and he
wants
a nice simple interface

--
deb


"Jeff Boyce" wrote:

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]
.



.



.