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: jalenben1
  • Content: Threads
  • Order by date
  1. jalenben1

    Average

    I have 2 or more MTTR times in my CR listed as follows: 2:48 2:46 3:15 The times were already calculate in a database before I brought it over in Crystal. I dont need to calculate the time differences at all. Now that I have those times I need to get the average of the times. The filed name...
  2. jalenben1

    VBA Help

    I have a text box in my form: ([qryHuaweiTicketsQuery.DateCreated])-([qryHuaweiTicketsQuery.Occurrence-Date]) AS [MTTR Response] This gives me the MTTR (Mean Time to Respond) which is what I want. I have a combo box with 5 catgories: SLA Criticality Target Critical 0:15...
  3. jalenben1

    Query Question

    Is there any way to query a vlookup in and SQL statement form a Pass through query? I have a SQL atatement below: SELECT qryHuaweiTicketsQuery.AssignedToGroup, qryHuaweiTicketsQuery.IncidentID, qryHuaweiTicketsQuery.Node, qryHuaweiTicketsQuery.AssetType, qryHuaweiTicketsQuery.Description...
  4. jalenben1

    Form Question

    I have a table in Access as follows: SLA Criticality Reponse Time Restoral Time Critical 0:15 4:00 Critical (Not Measured) 0:15 4:00 Major 0:15 8:00 Major (Not Measured) 0:15 8:00 Minor 0:35...
  5. jalenben1

    Query Form Help

    I have in my form a text box where I need to have populated if a ticket was Met or Missed. In my form I have 2 text boxes with formulas in my query that gives me both the MTTR Response and MTTR Restoral MTTR Response Time...
  6. jalenben1

    Query Help

    I have a query in Access and I need help on a formula. I have a feild called DateCreated and I would like to create a formula in the query with a fieldname called Week Beginning in which the beginning of the week would start off as 1/1/2011 based off the DateCreated fieldname; next create a...
  7. jalenben1

    New VB script

    I wrote a script and trying to get it to work. My Pass Through Query SQL is as follows: SELECT UNO_Incidents.AssignedToGroup, UNO_Incidents.IncidentID, UNO_Incidents.Category, UNO_Incidents.SymptomDeviceAlias, UNO_Incidents.Priority, UNO_Incidents.Status, UNO_Incidents.Type...
  8. jalenben1

    Sending Email electronically

    I am trying to send email from a form electronically. I have a command button called Email this report and I want to send the report to someone. I have the following script: Private Sub Email_ECM_Report_DblClick(Cancel As Integer) On Error Resume Next Dim strToWhom As String...
  9. jalenben1

    Scripting in VBA

    I have a form in Access and I am having a hard time with a VBA script. What I am trying to do is click on a button I created called Generate ECM report. I want to be able to type in a beginning date and a ending date to generate this ECM report. The script I have below is: Private Sub...
  10. jalenben1

    Formula

    In Crystal Report I have 3 times that I would like to get the average of: The field name is MTTR Restoral Time and the 3 times are as follows: 4:00 6:98 4:87 How to get the average of the times?
  11. jalenben1

    VBA Help

    I am trying to automate a report I do and I have the desired end report that I need. I am just trying to make sure that the data comes in cleanly. In the form I would like for the end users to put in a beginning and ending date and only the data between those dates appears in the report. The...
  12. jalenben1

    Calculating two dates in a form in Access

    I have a form I am creating in access. I would like to calculate the difference between two dates in the following format: dd:hh:mm:ss. The fieldnames I have is DateCreated and Occurence-Date. For example: Occurence-Date DateCreated 3/26/2010 4:37:00 AM 3/26/2010...
  13. jalenben1

    Calculate Difference of date/times

    I have a ODBC query that I created and made into a spreadsheet. From there I made the spreadsheet into a table in Access. I then created a query from the table. I wanted to add the following columns in the query with a calculation: Calculate MTTR Response Time: Date Created - Occurence...
  14. jalenben1

    ODBC Question

    I am trying to automate my database using MS Access. I have created a form in MS Access. I have also created an query using ODBC which imports to a spreadsheet. The name of the query is called Huawei Tickets Query.dgy. The ODBC query is an extension file called (.dgy). What I would like to do...
  15. jalenben1

    Dates in Excel

    I have a date in a cell that says 10/31/2010 16:38 PM from a database. How to format the date so that it will only have the date and not the extra stuff.
  16. jalenben1

    Automating a Form in Access

    I am trying to automate a report I do daily. I am using MS Access to do this. I was able to get a link to the database REMEDY using the ODBC connectivity. I have a query file (.dgy) that I use to generate this report. I then take that report and created a master spreadsheet that is loaded...
  17. jalenben1

    Access Problem

    I have a spreadsheet that I have been able to import into table in Access. For some reason now when I try to import the spreadsheet into Access it gives me "an error message that says an error occured trying to import". This has never happened before with the same file. I even tried to open...
  18. jalenben1

    VLOOKUP

    I have a column that have the following items below that is typed in the column based off the ticket in our ticketing database: Critical Critical (Not Measured) Major Major (Not Measured) Minor N/A This is the matrix that is used: Category Response Time Restoral Time Status...
  19. jalenben1

    VBA Script Issue

    I wrote this script in VBA in an Access form below: Private Sub lblHuaweiReporting_DblClick(Cancel As Integer) 'This code created in part by Command Button Wizard. On Error GoTo Err_lblHuaweiReporting_DblClick DoCmd.OpenForm "Huawei Reporting", acNormal, , , acFormAdd, acWindowNormal...
  20. jalenben1

    Formula in a Query

    I am trying to write a formula in Crystal Reports. I am trying to include the names of technicians in my report. There user names are used in the database but I want to see there real names. For example I have: If {Huawei_Dashboard.Owner} = "N1ANANDER" then "Antonio Anderson"; How to...

Part and Inventory Search

Back
Top