Query by site and date

[proulxsa]

I want to set up a query that will allow my users to select a site and a value based on todays date. We run machines that lower users electricity costs and we need to know on any given day what their demand reading is and how much we have saved them. I want the query to find the site and then find their ave demand reading for that month. The months are not normal months either. They are utility months and each site has different days. I don't think that I've been very clear, but any help would be appreciated.

Sarah

 

[KKilfoil]

One Option:
Get your customers to install an MV-90 interval utility meter, and let the meter perform your calculations for actual consumption.

How are things at Electroflow?

 

[proulxsa]

My life would be so much easier if that is what I could do. Instead we have technicians go out and read the meters. They call in readings and we need to tell them if there are demand savings left, and from that how long they could shut the machine off for maintenance.

Don't work for that company, I work for a cogen company.

 

[KKilfoil]

Describe the steps you would perform if you were to do your calculations manually. It would make it much easier to respond (at least for me).

I am not sure how and how often you are recording readings and how you know that you are into another billing period from the utility.

 

[proulxsa]

Ok.. The techs read the meter and call in the number (not on a regular basis) Say the number is .75, I want a caluclation to take that number and multiply it by that meters specific multiplier (already entered into the database). What I am looking for is a query that will then filter for that months average and compare the 2. I don't know if I am going the longest way possible for this, but in the table I have: site,readdate(ave date the utility reads the meter),metermultiplier,avejandemand,avefebdemand....and so on.

I would really like an iff statement that would somehow figure out if todays date is before or after the scheduled utility meter read and give me the correct month's demand. I would settle for it just filtering for that month whether or not they are into another billing cycle.

Does that help?? What I ultimately need is something that ANYONE in the office can use to let the techs know how long they can keep the machine down for (ie. no demand savings left..take your time!!)

(We are trying to convert all of our excel charts into a database so that only one person in the office has to input the data. Currently 3 different people maintain their own charts.)