Utility-Start End

Posted on 2011-10-06
Last Modified: 2012-08-14
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")

Question by:SFSDIT
    LVL 12

    Expert Comment

    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?

    Author Comment

    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?
    LVL 12

    Accepted Solution

    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.  

    Author Comment

    Still haven't had a chance to try it yet.  Maybe later today.  Thanks for the information.
    LVL 8

    Expert Comment

    This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
    Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now