AnsweredAssumed Answered

Functions help!

Question asked by KM on Jun 17, 2014
Latest reply on Jun 17, 2014 by philmodjunk


Functions help!




     I am creating a reconciliation database for water meters, with a lot of help from this forum I have been able to get it up and running!  I have different location numbers for each water meter and entries which record each water meter reading.  I am currently using the Last function to calculate the total amount each location has used but have ran into a problem. We have some entries that were not recorded from April and now when we put those into the database it is not grabbing the first date for each location... Is there another function that would work better? Or a way to modify the Last function to get it to take the most recent date-the oldest date?