Recent content by Hallel86

Thank you for the advice. I have come to terms that my source data is going to have to be restructured. I have restructured it and have found the calculations I need. Thanks!

Okay, so basically, I have a problem that I can't seem to solve in SQL for my access 2010 query. Let's say I have a the price of and for every year. In the tables I have A building number, a building type, and electricity and water predictions for this year and many upcoming years (up to 40...

Hi everyone, extremely new to SQL. Okay, basically. I want to calculate a field that is Sales*6+Salary, then in that same query I want to select ONLY the greatest Salary per employee. So for example SELECT EmpId, MonthDate, Sales, Salary, [Sales]*6+[Salary] AS SalTot FROM EmpTable S1 WHERE...

That was such a simple answer, yet the exact answer I was looking for. Sorry, I am still learning this stuff so I can help teach others at my job as well. Thank you very much

Okay, this one should be simple and can be solved in one of two ways. I have two seperate tables with a 12 digit identifying number that is ALMOST exactly the same in each. I am trying to match up these two tables, which works amazingly well, except for the occasional case where the 12 digit...

Yours works perfect! I am not sure about the "yourstotal" field, but everything else works well! Would you happen to know how to do this in SQL? I do not know VBA at all, so it is difficult for me to read.

That was helpful. I believe there is still something wrong with my code. I get results that are un-explainable by myself. Here are the results I get. Naturally, the last field is the running total.

Basically The last collum in my PDF is what I am looking for result wise. I have this so far, but I can not figure out why the numbers are not coming out correct, or if I am even close at all, lol

I am having trouble with this running total. Let's say I have a well. I am trying to create a running total that calculates the total Uptime (or hours operational) for each well every month. I feel like I am close, but I have been working on it all day and still haven't found my...

Silly question, but do you know why this would take like 3 minutes to query now? I have other queries that narrow down the data so it shouldn't take that long. and that code worked! Thank you! edit: nvm. I just made previous query into a table and it works fine now. Thanks.

This works at first, but when I add more fields like Well and Well_NO it complicates this I suppose and everything is duplicated again. How would I narrow this down with more fields? Edit: Correction, when I add dates it duplicates everything. Well and Well_NO will not change it from the...

I did a search and I came up short on finding what I need here. I am looking for a solution to display THE max value of each well. For example. I have an ID number, a well, well_no, d_date, production, and the four_day_peak (which will be the max value) I want to display ONLY the greatest...

Novice access user here! I am looking for assistance with a query. Let's say I have multiple buildings that I own. Each building earns a monetary amount each day. Some days they earn $0, some days they earn $1,000. This is all kept track in a data base in which someone manually enters the...

My name is Billy, I am an extremely novice access user. Our company decided they want to utilize access more to create reports and such. I have only been playing around with access for the past couple of weeks, and I am having a blast so far. I am slightly frustrated at the same time...