Search results

JHB it worked.. you are the man buddy Thanks a million

JHB I tried it but it missed up the whole calculation and started showing negative figures with totally wrong answers. I added the counterconstant in the counterName table. Now what ?

Tanks a lot my friend. will try it in couple of hours and get back to you buddy

JHB, My superhero Sorry for not giving you full info from the beginning as I totally forgot that i took copy of the consumption and not the equation :o:o The example attached has the data stored vertically with the Constants attached. I have unlimited faith in you my friend and thanks for...

JHB Actually I can't thank you enough for your efforts as you have helped me greatly buddy. I've gone through the code and now I can say that I understand somehow how it works. one last thing to ask you.. Some of the measuring points are found to have a constant factor for each one of them...

JHB thanks a lot my friend. May now you tell me how you did it so that I can apply it on my data base ?? I know I'm asking for too much .. thanks for your efforts

Here is a big sample my friend I'm really grateful for your efforts

Yes. By adding a meter I mean adding a new measuring point and I will indeed by storing the data vertically so can you help me find a way for this to be done automatically without having me to enter and manipulate the SQL every time I add or remove a measuring point ? And the Dlookup isn’t the...

JHB A million thanks to you buddy. Now I have the code and I can modulate it thanks to you. But that means that whenever I want to add or remove a meter I will have to go and change the code. Is there an easier way to do it without having to play with the SQL in the future ?

Here is a sample Kindly guys help me out here as this is a last item in my database and is putting all my work on hold.:(:mad:

There is a sample in my second or third post

So far my problem isn’t solved guys. I have been facing this problem for so long now and it is stopping my work. This is a small part of my database and I want it done. For sure there is a way of making this query run peacefully and to be ever running. Or like I asked before if a finction can be...

I entered the date but it showed error that the formula is missing something or it is too complex

What sort of value can it be ?!! And how will it affect the results ?!

Expr1: DLookUp("[Reading]","[Readings]","[MeterID] = " & [MeterID] & " AND [Date] = '" & Format([LatestDate],"yyyy-mm-dd") & "'")-DLookUp("[Reading]","[Readings]","[MeterID] = " & [MeterID] & " AND [Date] = '" & Format(DateAdd("d",-1,[LatestDate]),"yyyy-mm-dd") & "'") That's how I typed the...

I want to view it daily as in meterID and next to it the consumption daily. and I tried the dlookup before and it showed wrong values when it faces repeated readings. as you know you can face it sometimes when a certain area is closed and so the meter readings are constant for a while that's...

The meters are collected manually and handed to me in a paper form. I have the readings everyday so I'm never going to face a missing day or a missing entry. I need to see the consumption on daily basis and I'll generate a report to give me the data monthly. My only issue is doing the row...

OK, I understand what you are saying and it is logical to a big extent. but then you would mean that entering the meter reading data should be done after selecting the meterId from a combo box for example ??? but still if I did this, which is more realistic regarding adding more meters or...

In fact I have about 20 meters only that are stored daily at the same time to avoid duplication in the entries. the main issue is about doing the calculation itself as i have been looking for away around it for a very long time now even before sharing my issue on this forum. you people are...

I have attached a sample of what i want done in access. I haven't tried what was given to me yet but will do and get back to you guys and many thanks for your replies. Please review the example in the excel sheet and tell me if it can be done by creating a function in VBA that can do it ?