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 derfloh 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: *

  • Users: EBox
  • Order by date
  1. EBox

    VBA Macro to Pull Values From Excel Files into Summary Excel File

    What additional information is needed?
  2. EBox

    VBA Macro to Pull Values From Excel Files into Summary Excel File

    I haven't tried any code because I'm very new to VBA and this is way beyond my abilities. The row labels are: "Net Revenue" "Total expenses" "EBITDA %" "Visits" "RVU" Note that sometimes these row labels will be in different rows (e.g. "Net Revenue" may be on row 200 in one file but on row 252...
  3. EBox

    VBA Macro to Pull Values From Excel Files into Summary Excel File

    Hello: I have about 50 files in a certain folder where I would like to pull 4 values from each spreadsheet and assemble in a new "master" spreadsheet. Unfortunately, each file is not entirely the same layout structure, so I cannot simply pull all values from the files that are in discrete...
  4. EBox

    Finding Repeat Records within 72 Hours

    Hello: I am trying to find a way to write an Oracle query (11g) that finds repeat customers transaction purchases that occur within 72 hours of each other. Specifically, if a customer does a transaction on Day 1, and then again on Day 2, I would like to have a query that will pull the...
  5. EBox

    MS Excel Macro for Graphing

    Sorry, I meant "Column". Each of the IDs above would be represented in the Legend, with each of the columns above shown on the x-axis. The y-axis would show the % value for each ID/Column above.
  6. EBox

    MS Excel Macro for Graphing

    ID Level 1 Level 2 Level 3 Level 4 Level 5 Crit Care Obs Codes Total Mcare 4 Total Mcare 5 13 0.012484395 0.043695381 0.446941323 0.310861423 0.1360799 0.008739076 0.041198502 0.289855072 0.362318841 19 0.024390244 0.024390244 0.585365854 0.195121951 0.170731707 0 0 0.4 0.4 60 0.019230769 0...
  7. EBox

    MS Excel Macro for Graphing

    I posted the data file in my initial post (see link). THe y-axis is a percent and is populated in the Excel file. Perhaps that was done by default?
  8. EBox

    MS Excel Macro for Graphing

    Ok, I did this - see code below. But not sure how I would condition for the future revised source worksheet that may have less or more rows (I don't want to exclude records if there are more records added in the future, and don't want to have blanks in the graph if there are less records...)...
  9. EBox

    MS Excel Macro for Graphing

    Hi: I am a real amateur when it comes to Excel macros and I need to find a way to create a bar graph from a simple table in Excel (I have attached a link to the file - data source is on "new data (2)" tab and desired graph is on the "Chart1" tab. Can anyone help with writing a macro that will...
  10. EBox

    Outlook Assigning Tasks

    Hello: I often want to assign Tasks in Outlook to other people, which I do. However, when I assign the task, the Category I have assigned seems to get deleted (because I suppose I am not the "owner" anymore, but I would still like it to remain in a category I assigned it to). Is there a way...
  11. EBox

    Calculating Median in Access Query Across Groups

    Thanks for the guidance - I put in your changes and now get a Run-time error '3021': No current record. I should mention that the [DOS] field I have is in mm/dd/yy format, and I even tried changing your query recommendation above to match that, but received the same error. This [DOS] field...
  12. EBox

    Calculating Median in Access Query Across Groups

    Hello: I have spent numerous hours evaluating VBA code I found on the internet to calculate Median in a query. The only problem is that I would like to get median values for each date presented in the query result, and the VBA code I am using (the only one that worked) calculates the same...
  13. EBox

    Importing/Linking Daily Files

    What would the code consist of? I am not really a coder, so any help you could offer would be appreciated. Thank you, EBox
  14. EBox

    Importing/Linking Daily Files

    I would love for it to happen automatically, if that's possible, instead of having to push a button on a form. I do have the import specs loaded up into Access currently, but do not have any append queries. I have been manually just taking all the fields from the imported table and creating...
  15. EBox

    Importing/Linking Daily Files

    Hello: I have an Access DB which I import a daily text data file into and then run an append query in order to aggregate it to a cumulative table. I was wondering if there is a way to set up a macro or VB to automate this for me. The daily file name format is ED_Archiveyyyymmdd.txt (example...
  16. EBox

    Query With Time Values

    I get the following error when I run that: Between operator without And in query expression 'QryDatehours.Datehours Between [everything tester].[Arrive_Time]'. Any thoughts?
  17. EBox

    Query With Time Values

    Ok, so I played around with the SQL but I get a Data type mismatch error with this. Any thoughts? Would greatly appreciate it! Thanks, Eric SELECT QryDatehours.* FROM [everything tester] LEFT JOIN QryDatehours ON [everything tester].Arrive_Time = QryDatehours.Datehours WHERE...
  18. EBox

    Query With Time Values

    Thanks. I'm a bit of a rookie, so after I created the digits table, and the first query, which shows each date from my start date, and every hour, on the hour. I'm not quite sure how to create the second query, however. I can select the field from the first query, but what fields am I joining...
  19. EBox

    Query With Time Values

    Hello: I am trying to set up a query to look at counting number of customers in a department at any time (census). I have: [Arrive_Time], which is the time the customer arrives in mm/dd/yy hh:mm format [Archive_Time], which is the time the customer leaves in mm/dd/yy hh:mm format What I...
  20. EBox

    Saving Files in Access

    Thanks - this is good to know that it can be done. One other question on this - the requester has asked to somehow "sync" relevant details related to cases. In other words, for the various meetings and notes in the meeting box within Outlook, if there is a specific reference to "ABC Case", it...

Part and Inventory Search

Back
Top