Recent content by siouxprincess

Thank you JANR for testing the code out and boblarson it was the enable setting. :)

This code worked fine in Access 2003 to convert time into the format 00:00:00, but it is not working in Access 2007. I need help with how to modify this code. Function ConvertMinutes(minutes As Variant) As String If IsNull(minutes) Then ConvertMinutes = "N/A" Else Dim...

Thanks for trying to help RuralGuy. I figured out the statement I needed: =ConvertMinutes(Avg(IIf([sys_eusername]='Production',[sys_request_24mins]))) If I want to get a sum, all I needed to do is change "avg" to "sum". :)

This is for a report. I have a module that converts 1h 2m into 1:02:00. I'm trying to sum the time for a group, Production. =ConvertMinutes(Sum([sys_eusername]='Production')) However, it is giving me a negative time return. And Access does not seem to like if I try...

This is for a report. I'd like to convert minutes to time in the format: hh:mm:ss Example: 4762 minues is 79:22:00 The field is: sys_request_hdmins This is figured for an 8 hr. work day.

Gratitude Thanks lark, Rich and Brian for giving me suggestions. ;) :) :p

=Sum(IIf([usr_Origin]='Internal Software Error',1,0)) answer to my first problem... =Sum(IIf([usr_Origin]='Internal Software Error',[usr_elapsedtime],0)) answer to the second part of my problem... FYI -- In the table it's "Internal Software Error". However, when it is viewed, it is "Internal...

=Sum(IIf([usr_Origin]="Internal Software Error",1,0)) Error message is gone. However it returns an answer of 0 instead of 1 (that I need as the answer). If I use: =Count(IIf([usr_Origin]="Internal Software Error",1,0)) it counts all five origins (each one is different). Any suggestions?

=Sum(Iif([usr_Origin]="Internal Software Error"),1,0) I've tried this code, but I'm getting an error: the expression you entered has a function containing the wrong number of arguements. Any suggestions?

Design of report I'm trying to produce is this: report header: title of report page header: dept, id #, open date, closed date, origin, summary, desc, solution detail: dept group, id #, open date, closed date, usr_origin, summary, desc, solution time to close: usr_elapsetime page footer...

Hello, The table I work with is my employment's help desk database. I need to add up each of the values of the usr_origin field and the total of the usr_elaspedtime field that corralates with each value of the usr_origin field. There are 16 different values for the usr_origin. As an...