If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#21
|
|||
|
|||
Meter Readings
"Sandy Mann" wrote in message ... I had noticed *empty* posts like the one above before and wondered why. I posted a reply this morning at work through Google and all that has shown up is Pete's original post. I must have done something wrong I suppose. Anyway what I posted was: "Pete_UK" wrote in message oups.com... adding back in 10 raised to the power (number of dials). The formula from Sandy seems to be getting very complex. It's would not be so bad if it was just complex but it is wrong to boot! What I should have posted was: =MOD(LOOKUP(10^LEN(C2),D2:IV2)-LOOKUP(10^LEN(C2),D2:IV2,C2:IV2),10^LEN(C2))*B2+(( LOOKUP(10^LEN(C2),C2:IV2,C1:IV1)"")*10^LEN(C2)) But I would think that if there was any chance of the meter turning over more than its capacity then Maria should be looking at replacing the meter with one of greater capacity. I couldn't get this one to work Sandy - sorry ! It just gives me a zero for an answer each time. The meters never go round more than once, quite often not going all the way round for many many months Thanks again. Tracey |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Select query - only one-to-many records? | AndyK | Running & Setting Up Queries | 4 | March 27th, 2006 05:52 AM |
Latest meter reading | Dan Johnson | Running & Setting Up Queries | 2 | April 25th, 2005 09:53 PM |
Need to create a progress meter while an Access module runs | Brent E | General Discussion | 5 | January 29th, 2005 12:25 AM |
query progress meter | Bob White | General Discussion | 8 | December 6th, 2004 12:57 PM |
Trying to get difference in Meter readings between rows | Mike S. | Running & Setting Up Queries | 2 | June 8th, 2004 07:05 PM |