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...
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
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.