Search results for query: *

Nope ... Still dings anarchy@insync.net e-mail me and I'll send a CSV of the data to you

Field names ACDCalls (Round numbers from 1 to ~ 400) RONA (Round numbers from 0 to ~ 30) AvgACDTimeMin (2 decimal place numbers from ~2 to ~ 30) AvgACWTimeSec (2 decimal place numbers from ~2 to ~ 30) PercentAvail (%) ACDCallsPerAvailHour (2 decimal place numbers from ~.5 to ~ 4) All are...

CODE NOW With rst .MoveFirst intValue = rst!ACDCalls intLastCount = 1 Do While Not .EOF If rst!ACDCalls = intValue Then rst!SCOREACDCalls = intLastCount Else rst!SCOREACDCalls = rst.AbsolutePosition + 1 intValue = rst!ACDCalls intLastCount = rst.AbsolutePosition + 1 End If .Update...

Nope ... Still dings

Hmm ... No it just 'dings' when I try to run it ... I have tried it with both VARIANT and INTEGER in the dim area CODE BELOWRepeated for RONA and PercentAvail Public Function ReturnScore() DoCmd.SetWarnings False DoCmd.RunSQL ("Delete * From tblTempSortingAndScoring;") DoCmd.RunSQL...

OK ... First off, thanks for all your help ... I am MUCH farther on this now than I thought I would be @ this time Changing the type to DOUBLE solved the rounding issue :-) The parts that may TIE are RONA, ACDCalls and PercentAvail Score categories for each are SCORERONA, SCOREACDCalls...

Getting an error in that area now Compile Error: User-Defined type not defined It then points to this line in yellow Public Function ReturnScore() and this portion is highlighted as well new variables of the Add new variables line

And this code replaces the code for that particular scoring entry or it appends it

OK ... Most of it is working ... Two minor issues 1. Ties ... There can be ties in one of the categories that should be averaged together for a result IE: Three people get 10 calls and thus should be scored the AVERAGE of their 3 combined scores. 2. The original numbers are not coming over...

Is there a way to make some of the scores reversed? IE: 200 in Time is a lower score than a 100 in Time but 200 in Calls is higher than 100 in Calls.

OK ... Couple of questions Paul Where does this code go? Modules?

Right now this is all done manually ... I see no reason Access can't do it though. I have a group of 16 CSR's that have 6 categories they need to be ranked on. 16 is the best and 1 is the worst. Ties are possible but not likely. Each category has it's own range that is different from all the...

OK ... But that's what I need help with ... How do I write an expression to rank each column?

I would like to create a sorting and scoring sheme in Access across a number of fields in one table. If necessary, generating another table from the query. Table has a number of categories for employees. Each category has a number associated with it. I want Access to sort then score each...

I would like to create a sorting and scoring sheme in Access across a number of fields in one table. If necessary, generating another table from the query. Table has a number of categories for employees. Each category has a number associated with it. I want Access to sort then score each...