Search results

  1. H

    an iif statement that would change the value to multiple fields

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

    Selecting a new calculated field in same query

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

    Removing/changing numbers

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

    Running total - Monthly

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

    ONLY display max value for each ID

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

    Specific Date range based off of other data

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

    Greetings! & two questions!

    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...
Back
Top Bottom