Ok, So I am not sure if this is the best place to post this, so correct me if I am in the wrong place.

Let say I have an array of data. In this array, It has 4 Columns, represented as:

Column 1 = Customer #
Column 2 = Customer Name
Column 3 = Past Order #
Column 4 = Past Order Amount

Each Row in the Array represents a past order, so the array has no known upper limit.

End result is that I need to report in my VB app, the number of Unique Customers, and by that Customer, summarize the number of orders, and the total amount of those orders.

Any assistance is appreciated. Sorry for such a newbie question.

8 Years
Discussion Span
Last Post by __avd

Learn/Use the Linq - Language Integrated query,

Dim Ar As Integer() = {11, 22, 11, 22, 33, 33, 22}
Dim totalGroups = Ar.GroupBy(Function(p) p).Count
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.