Search results for query: *

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

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

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

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

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

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

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

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?

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

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

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

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

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

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?

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

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

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

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

I am sorry. The week starts from Saturday to Friday. In this case 1/1/2011 to 1/7/2011

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