Member Avatar for swulm

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.

  • 2 Contributors
  • 1 Reply
  • 85 Views
  • 23 Hours Discussion Span
  • Latest Post Latest Post by kvprajapati
Member Avatar for kvprajapati

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
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.