Ive gotten the file to come up in the list box but thats about it

1) A Comma Separated file contains an unknown number of entries. Each entry (record) contains a sales record. The sales record has the following information
SalesClerkID example 12345
Date of Sale 01/01/01
Amount of Sale $125.83
SaleItemSKU 837593

Each field is seprated by commas in this text file. the text file can be assumed to have records already sorted in the order of SalesClerkID

Your task
Record each record
Display on the screen the clerk's ID # and the amount of the sale
At the end of the clerk's sale(befored printing the next clerk's sales) display "Total:xxxxx Count:xxxxx Average:xxxxx" total sales amount, number of sales and the average sale for that clerk
skip one line between clerks
at the very end, print the grand total for all clerks and the average sale amount for all clerks
while you are told the records are alredy in sales clerk order, you dont know how many records or how many clerks, etc

GUI has a button and a listbox for output

txt file

this is what i have
Public Class Form1
Structure Clerk
Dim ClerkID As String
Dim DOS As String
Dim Amount As Double
Dim SKU As String

End Structure

Private Sub LstClerks_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles LstClerks.SelectedIndexChanged

End Sub

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim Clerks() As String = IO.File.ReadAllLines("E:/Question4.txt")
Dim query = From line In Clerks
Let data = line.Split(","c)
Let ClerkID = data(0)
Let DOS = data(1)
Let Amount = data(2)
Let SKU = data(3)
Select ClerkID, DOS, Amount, SKU
For Each Clerk In query
LstClerks.Items.Add("ID" & Clerk.ClerkID & " " & "Amount of Sale" & Clerk.Amount)


End Sub

End Class