Recent content by 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...

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...

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...

I finally did manage to get it to work with macros. I used the DCount as a condition for the MsgBox. My biggest problem was that I had my fields reversed in the formula.

I am trying to create a macro that will display a message if another record has the same information (ie. ***Top Priority*** has been selected for 2 different projects). I want it to warn the sales guys that someone else has assigned an analysis Top Priority and they should come see me to...

I am trying to run a query of multiple queries which will return the last date and hours logged since a certain part was serviced. I have individual queries set up to return the most recent service date/hour for each part (all return the most recent for that part). When I run a query based off...