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
  • 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

    Query Question

    AceMan I guess I am not being clear enough. I have this query I have created. Within my query I was able to calculae the MTTR (Mean Time to Respond) with the two fields DateCreated and Occurrence-Date. I got myy desired results I was looking for. What I was asking if there was a formula I...
  3. 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...
  4. 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...
  5. 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...
  6. jalenben1

    Query Form Help

    Another question regarding what I sent.....would it be better to have the query to show if a ticket was Met or Missed? Below if my SQL statement SELECT qryHuaweiTicketsQuery.AssignedToGroup, qryHuaweiTicketsQuery.IncidentID, qryHuaweiTicketsQuery.Node, qryHuaweiTicketsQuery.AssetType...
  7. 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...
  8. jalenben1

    Query Help

    I am thinking that I can format the date to show in the format mm/dd/yyyy in the textbox in a form. Eventually from the query I will used those two date fileds in a form. Am I on the right track?
  9. jalenben1

    Query Help

    Thanks dhookum and PHV I believe this formula will work for me: Month: Format([qryHuaweiTicketsQuery.DateCreated],"mmmm") It is giving me the name of the month from the created date. Earlier you gave me the formulas for week start: WeekStart...
  10. jalenben1

    Query Help

    That formula is not giving me the month Month(DateAdd("d",-Weekday([qryHuaweiTicketsQuery].[DateCreated])+7,[qryHuaweiTicketsQuery].[DateCreated])) Basically I need a formula that is based on the DateCreated fieldname and the Restoraldate. If there is a date in the DateCreated then I want to...
  11. jalenben1

    Query Help

    dhookum: The formula you gave me initially worked but I had to tweak it toget what I needed: DateAdd("d",-Weekday([qryHuaweiTicketsQuery.DateCreated])+1,[qryHuaweiTicketsQuery.DateCreated]) As...
  12. jalenben1

    Query Help

    Could I use the formula in a text box in a form DateDiff([qryHuaweiTicatetsQuery.DateCreated])-[qryHuaweiTicketsQuery.Occurence-Date])?
  13. jalenben1

    Query Help

    Can you tell me if I am calculating this right. I am trying to gett the difference between two times in hours:Minutes:seconds. I have the DateCreated fieldname and I have the Occurence-Date fieldname. In the same query as above I want to add that. So far I have...
  14. jalenben1

    Query Help

    Now that I have the week start and week ending dates how to format it to show only the dates itself and not the times with it?
  15. jalenben1

    Query Help

    dhookum: I changed the 7 to a 6 and I have the correct week days beginning and ending.
  16. jalenben1

    Query Help

    dhookum: I modified your suggestion as follows: SELECT qryHuaweiTicketsQuery.AssignedToGroup, qryHuaweiTicketsQuery.IncidentID, qryHuaweiTicketsQuery.Node, qryHuaweiTicketsQuery.AssetType, qryHuaweiTicketsQuery.Description, qryHuaweiTicketsQuery.CreatedBy, qryHuaweiTicketsQuery.Status...
  17. jalenben1

    Query Help

    dhookum: When I tired your suggestion, I got the following error message: Extra ) in query expression 'qry.HuaweiTicketsQuery.[DateAdd("d",-Weekday([DateCreated])+1, [DateCreated])
  18. jalenben1

    Query Help

    Maybe this will help: Here is my SQl statement below SELECT qryHuaweiTicketsQuery.AssignedToGroup, qryHuaweiTicketsQuery.IncidentID, qryHuaweiTicketsQuery.Node, qryHuaweiTicketsQuery.AssetType, qryHuaweiTicketsQuery.Description, qryHuaweiTicketsQuery.CreatedBy, qryHuaweiTicketsQuery.Status...
  19. jalenben1

    Query Help

    I am sorry. The week starts from Saturday to Friday. In this case 1/1/2011 to 1/7/2011
  20. 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...

Part and Inventory Search

Back
Top