Search results

Thanks pbaldy....that's exactly what I was looking for. You get the gold star. I appreciate the help that I have received from all of you. Thanks Again, Corwin

I'm still struggling with the function, but the SQL code works nicely (thanks pbaldy) except for one thing...I'm looking for the difference for the last reading, not for all of them. I'm currently trying to sort/filter the SQL query to end up with just the last reading. (This is the first time...

Apologies...but I'm obviously tackling something beyond my skill level (willing to learn though.) I quickly created a small database and populated it with some data for testing. I copied the function, made the changes (I hope correctly), and saved as a module in the test database. Then I...

I was able to find the function that ajetrumpet suggested, but I don't uderstand how to make it work. Where do I enter the code to make the function work? Do I need to change the datatypes? (I'm working with numbers, not strings) Again, I'm a noobie at this and probably just need a nudge in...

The structure that you have shown is accurate...I haven't thought of transposing the data. I will see if I can find the function and give it a try. I will keep you posted and thanks for your help.

I'm new to building databases and I wouldn't think that this is difficult but it has stumped me and everyone that I have approached to elegantly perform this calculation. Essentially I have a table of meters (the best real world example is the watermeter that your community uses to measure how...