• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 333
  • Last Modified:

Utility-Start End

I have a question to ask.
This is the utility table we have.
Is there any way to have "End Time" gone to "Start Time" of the next month automattically?
(For example, if we choose "October" from the month field of the utility table, the value of end time from the "September" goes to start time of the "October")

StartEnd.jpg
0
SFSDIT
Asked:
SFSDIT
  • 2
  • 2
1 Solution
 
North2AlaskaCommented:
I'm not sure I follow.  Are you looking to calculate the start time of the next month or join to a table with the data?
0
 
SFSDITAuthor Commented:
Thanks for the reply, good question maybe a calculation might work.  our Electrician goes to apartment to apartment and reads the meter.  As this is a new DB he has put in the start time the very first time he used it, for example,  a apartment's meter had 100 kwh and then the reading at the end of the month showed 250 show the DB for a 150 KWH used.  We basicallly want the end reading (the 250 KWH) to automatically pop up in the next months start reading.  Any ideas?
0
 
North2AlaskaCommented:
OK, I think I see what you want.  When you create a new entry you would like to display the value from the last entry in order to calculate the amount used.  The key is to have a self join to calculate the previous reading date and then a second join to pull in the previous reading.

Take a look at this sample and see if it will work for you.  
Previous-Value.fp7
0
 
SFSDITAuthor Commented:
Still haven't had a chance to try it yet.  Maybe later today.  Thanks for the information.
0
 
TocacarCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now