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 Rhinorhino 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
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. EBox

    Saving Files in Access

    Hello- I am wondering if someone can answer a basic question for me. I was asked to develop an Access database that tracks legal cases. Specifically, in addition to entering data like "journal" (i.e. diary type entries including date, comments) entries, the requester is looking to attach...
  9. EBox

    Report Setup in Access

    I was hoping someone could help me with creating some reports in an Access database. I currently have a Form which shows 1 record at a time where I populate complaint information from a customer. As many of the complaints fall into about 9-10 categories, I have standard templates for letters...
  10. EBox

    Excel - Data Labels

    Hi - I am setting up a simple columnar chart in Excel which graphs values in my spreadsheet related to individual performances. The x-axis shows the name of each performer. I have another field which is for "comments" that explains outlier values which I would like to use for data labels, but...
  11. EBox

    Strategy for Designing Form

    Hello: Would appreciate someone's thoughts on how to design a form in Access- I have an Excel file with multiple tabs that each contains people's names and addresses. I would like to build a DB that imports each tab into a "master table" and creates a new field for each record which is the...
  12. EBox

    Crosstab Query Help

    Hello: I am trying to make a crosstab query (I think) from a Select Query. The select query has 24 with fields corresponding to each hour of the day ("12A", "1A",..."11P") and DOW (for day of the week). I would like to sum the value in each of the time fields and have that run vertically...
  13. EBox

    Sorting a report using values in multiple fields

    Hi: I have a table that captures the names of workers in 3 fields, "Staff1", "Staff2" and "Staff3" for each record. I would like to create a report which sorts by staff name, but I'm not sure how to pull up all records for a staff member when they could be listed in any of the aforementioned 3...
  14. EBox

    Writing a Query to Identify "First" Value

    Hello: I am running a query against a data table which has the following fields: ID Number Function Event DateTime I am looking specifically at all records where [Function] = "ADT". For these, there are sometimes mutliple occurences for each [ID Number] because this event happened several...
  15. EBox

    Finding Second Occurrance of String Using Query

    Hello: I am a novice Access user, and am using a dataset which represents "event log" activity on an electronic medical record system for a hospital. Each record in the dataset has a unique patient identifier, event time stamp, and indicates the field name that is being changed, the old value...
  16. EBox

    Excel VB Macro For Moving Cells

    Hello: I am pretty new to VB with Excel, and I'm hoping someone can help with write some code for something which is probably pretty easy for some of you. I have a series of Excel files with cell values in a certain layout, and I really just want to create a macro that will "transpose" the...
  17. EBox

    Use of Form to Satisfy Query Prompt

    Hello: I have a query (Percentages 2)which uses about 6 sub-queries, each of which have a prompt of [StartDate] and [EndDate], so I can aggrgate individual table data into one master table. I then have a form, Form1, which points to Percentages 2 so when I open the form, it asks for a...
  18. EBox

    Access Query to Provide Totals and % of Total

    Hello All: I am trying to run a query that will allow me to view the total of several numeric fields in a query, and then create a column for each that calculates the % of each row of the total. The numeric fields are...
  19. EBox

    Linking FoxPro Tables to MS Access - Missing Records

    Hi: I am linking my MS Access 2003 app to a FoxPro database. I have a successful ODBC connection, and can link to all tables. However, when linking to one particular table, I am unable to view all records. I am told by the FoxPro data administrator that the records I cannot see are marked as...
  20. EBox

    Excel Worksheet Names From Cell

    Is there a way to name an Excel worksheet tab with the contents of a particular cell within that tab? For example, whatever is in cell A1 would be the name that appears on that tab? Any help is appreciated. Thanks, EBox

Part and Inventory Search

Back
Top