Search results

Thank you so much for taking me seriously Dave. Week 5 doesn't happen because they only do 4 weeks each month to get a sample of the agents abilities as this is a performance review and action plan. Not only do I need to compare the weeks but I also need to build the action plan based on...

Alright alright... This project may not happen then. I swear the rest of my database makes sense tho....

I am quite aware of the differences between Access and Excel. My database doesn't need to be redesigned. I have quite the little system here built and working. The table in question however probably does need redesigning and that is exactly why I'm on here asking for help. I've simply stumbled...

File attached: example of excel SKEP (the part in question, as there is so very much more after I'm done with this section) The darker blue area near the bottom is where the call segment that needs the most improvement populates and is where my subform is in my form. (subform that is coming...

Ok, I work in a call center. I'm designing a database that allows all the coaches (supervisors) to view the stats for each agent on their team. At this point I have accomplished this including the scorecard combining stats from all parts of the database. Next step is to move something called the...

Ok, with that in mind as a potential option I have another question... My table (tblCallProcessAnalysis) has info for 4 weeks with 64 fields per week plus 4 showing Agent Name etc.. I know I can put in the fields for one week showing 68 fields total instead of all 260 and simply input a...

I have a table that requires 260 fields for a specific reason. Is there any way to bypass the max number of fields allowed in a table? Thanks, Canadian

It's ALIVE!! Function getMinuteFormat(in_Seconds) As String ' converts numeric seconds (in_Seconds) into a string that displays minutes (i.e. 340 = "5:40") Dim ret As String ' variable to hold value to be returned, by default Dim mins, secs As Integer ' variables to hold minutes and...

I have tried a few things including: secs = IIf(in_Seconds Mod 60 < 10, Format(in_Seconds Mod 60, "00"), in_Seconds Mod 60) and it's not making a difference... what am I missing?

No I didn't build it, I totally stole it from another thread... I'll keep playing tho. I added: min = Int(in_Seconds / 60) and I'm getting a full minute now. At this point all I have to do is figure out how to make 5:3 show as 5:30 or 5:03 and I'm all set :)

Sorry I hurt your brain... hahaha we're getting close tho! The values my report is giving me look like this: 5.1090154102776:7 min = in_Seconds / 60 is great but I need it to omit everything between the decimal and the colon since it is part of a minute and therefore taken care of with secs...

Is this what I'm looking for? Format(Int(((in_Seconds) - (Int((in_Seconds) / 3600) * 3600)) / 60), "00") & ":" & Format((((in_Seconds) Mod 60)), "00") I tried it and I get an error saying that the first "&" is expected to be an "="... I'm sure I seem like I know what I'm doing, but it's mostly...

THANK YOU SO MUCH!! I've got it working except for the formatting code I was supposed to enter... How do I enter it into a module if it has specific field names in it and I want to use it for multiple fields? Do you have an example I could try?

Hello All, Basically, I get daily reports from the client and the AHT and ACW values come in seconds. I've recently added code to the query changing the data to nn:ss which works perfectly. Below is some info: tblTelephony [AgentName] [Calls] (number of calls answered) [AHT] (in seconds)...