Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Drivium

    Form manipulation via VBS - need form to update after 1st selection

    some *kind
  2. Drivium

    Form manipulation via VBS - need form to update after 1st selection

    Yea, I tried a delay. I think I need to reference some time of form function, but not sure how to do that. If you go to that link and select an object in the first drop down, you see the subsequent dropdowns change. I have to trigger THAT somehow...
  3. Drivium

    Form manipulation via VBS - need form to update after 1st selection

    Does my question make sense? I'm happy to clarify. TIA!
  4. Drivium

    Form manipulation via VBS - need form to update after 1st selection

    I created a script to BEGIN to do what I need. This script interacts with the initial form. I can fill out the form and submit, but it errors. Upon further inspection, after a selection is made in the first dropdown field, the form is supposed to refresh with updated dropdown options. With my...
  5. Drivium

    3 Month Rolling Average

    Getting same results as my attempt. 3month oil_vol and standard oil_vol match values.
  6. Drivium

    3 Month Rolling Average

    Thanks for the reply. I changed up the WHERE ?, but not understanding which date reference I should change or what to change it to. Not totally sure I applied your last suggestion correctly either. Now Oil volume and average oil volume are identical. SELECT; SELECT A.Well_Name, A.Test_Date...
  7. Drivium

    3 Month Rolling Average

    Also, I really need this to SHOW the following columns Well_Name, Test_Date, Oil_Vol, Water_Vol, Gas_Vol, Water_Cut, 3Mon_Avg_Oil_Vol, 3Mon_Date, 3Mon_Avg_Water_Vol, 3Mon_Avg_Gas_Vol, 3Mon_Avg_Water_Cut,Delta_Oil_Vol, Delta_Water_Vol, Delta_Gas_Vol, Delta_Water_Cut. For the 3 month avg date...
  8. Drivium

    3 Month Rolling Average

    Ok...got it to work...sort of. But I'm getting the same problem as before where the data is not unique to each well. But instead, showing the same data for each well (depending on date) SELECT A.Well_Name, A.Test_Date, A.Oil_Vol, A.Water_Vol, A.Gas_Vol, A.Water_Cut...
  9. Drivium

    3 Month Rolling Average

    No luck. I've tried putting commas after each (Select statement, but it's not working. I either get a syntax error or punctuation error...
  10. Drivium

    3 Month Rolling Average

    Something like.... (not working) Got error saying "The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect" SELECT Well_Name, Test_Date, DateAdd("m",-3,[Test_Date]) AS SinceDate, (SELECT AVG(Oil_Vol) FROM 3Mon_Average_2...
  11. Drivium

    3 Month Rolling Average

    That worked. Now trying to apply it to the rest of my criteria and getting an error about an extra ) SELECT Well_Name, Test_Date, DateAdd("m",-3,[Test_Date]) AS SinceDate, (SELECT AVG(Oil_Vol),AVG(Water_Vol), AVG(Gas_Vol),AVG(Water_Cut) FROM 3Mon_Average_2 B WHERE B.Oil_Vol = A.Oil_Vol AND...
  12. Drivium

    3 Month Rolling Average

    I must have applied the technique wrong... every well has the same average for the same time period. When the date moves up a day, the average changes (but is the same) for all wells still. SELECT Well_Name, Test_Date, DateAdd("m",-3,[Test_Date]) AS SinceDate, (SELECT AVG(Oil_Vol) FROM...
  13. Drivium

    3 Month Rolling Average

    Regarding well testing: Posted 5 months worth of data in the attached spreadsheet. Basically I have 6 columns of data: Well Name Test_Date Oil_Vol Water_Vol Gas_Vol Water_Cut I need to calculate a rolling 3 month average per well on oil,water,gas, and water cut. Easy to do in Excel, but not...
  14. Drivium

    Evaluate Date in Text string with vlookup help!

    I think for this instance, I am in need of a specific formula for my spreadsheet. Ive been reading non stop on this since my original post, but can't seem to translate any formula to work with my spreadsheet. In this version, I've cleaned up a lot of the data improved the function in general...
  15. Drivium

    Evaluate Date in Text string with vlookup help!

    Which index? =index(theFormula,1,1) or =index(theFormula,count(theFormula),1)
  16. Drivium

    Evaluate Date in Text string with vlookup help!

    Any chance you can throw out an instance of what you are describing... I still can only get the first instance. I don't get how to reference more than 1 row. Like for LCP017 for example.
  17. Drivium

    Count cells like "Pending*" and date within quarter help!

    I have a spreadsheet with 4 columns representing quarters (Q1-Q4). For each quarter there are mixed dates and text in the cells. For cells with "Pending*" and dates that fall within that quarter, I need to count the occurences. This number represents the number of failures for that well, for...
  18. Drivium

    Evaluate Date in Text string with vlookup help!

    I'm making an assumption that I can use VLOOKUP in this way. I'm assuming that FALSE means the first instance that matches the well, and TRUE means any other instance that matches the well. I wonder if there is a way to take the max of the vlookup findings? I'm sure the problem isn't your...
  19. Drivium

    Evaluate Date in Text string with vlookup help!

    EDIT - you have to click SHOW CALCULATION STEPS
  20. Drivium

    Evaluate Date in Text string with vlookup help!

    When I get the #VALUE result with...

Part and Inventory Search

Back
Top