1.11M Members

Visual Basic Arrays

 
0
 

I need to make an array using the following info.

Salesperson January February March
1 2400 3500 2000
2 1500 7000 1000
3 600 450 2100
4 790 240 500
5 1000 1000 1000
6 6300 7000 8000
7 1300 450 700
8 2700 5500 6000
9 4700 4800 4900
10 1200 1300 400

I am making an application that will calculate a bonus of whatever percentage value for all 10 people based on their sales for the three months above. The text box display will show what the bonus will be for all the sales people and how much is paid in bonus total for all.
Thanks in advance for any help.

Rob

 
0
 

Hi there. I hope this will help! ~ Sheryl

Dim aRay(9, 3)
        aRay(0, 0) = "John Salesman"
        aRay(0, 1) = 2400
        aRay(0, 2) = 3500
        aRay(0, 3) = 2000
        aRay(1, 0) = "Sue Seller"
        aRay(1, 1) = 1500
        aRay(1, 2) = 7000
        aRay(1, 3) = 1000
fill in the remaining items here...

        Dim x, y As Integer
        Dim sales As Double = 0
        For x = 0 To aRay.GetUpperBound(0)
            sales = 0
            For y = 1 To 3
                sales += aRay(x, y)
            Next
            Debug.Print(aRay(x, 0) & " Sales: " & sales)
        Next
You
This article has been dead for over six months: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article