okay..thanx so much..
another one mre qn!(:

the task which i'm doing is to actually assign the ticket submitted bny the user to a support staff automatically so they can attend to it..these support staffs have their own quotas..
so i came out with this formula to implement this concept..

the formula is -> QuotaAns = (1 / (TotalTickets + 1)) * Quota

the quotaAns will determine who to give the ticket to..this formula muz calculate for all the support staff and see who has the highest quota will receive the ticket..

for example: if support Staff A's Quota is 50% and B's quota is 30% and C's quota is 20%
the formula will be implemented this way: QuotaAns = (1/(1+1))*50%

so this will be used for all the support staff and who has the highest quotaAns gets the ticket.
the 1 always remains the same because its the one new ticket..total ticket is for that particular staff which will be accumilated..

i've got to implement this in my codes and i did this :

Public Function CalculateQuota() As Double
Dim newTicket As Integer = 1
Dim TotalTickets As Integer
Dim Quota As Double
Dim QuotaArr As String
Dim QuotaAns As Double

QuotaAns = (1 / (TotalTickets + 1)) * Quota

If QuotaAns < ((SupportStaffID = "10") And (SupportStaffID = "11") And (SupportStaffID = "15")) Then
End If

End Function

but i'm stuck half way..i don't know how to move on..any help pls??