Member Avatar for Stevon
Stevon 0 Newbie Poster 
sub HighestMark
open "Z:\Program\Assignment\StudentGrades.txt" For input as #StudentGrade
while eof(#StudentGrade) = 0
    input #StudentGrade,Id$,Name$,DOB$,Sub$,Grade
if Grade > Highmark then
    Highmark = Grade
end if
wend

print "Congratulations "; Name$; " Has Won £500 For Attaining "; Highmark; " in "; Sub$
end sub

how would i go about by showing the subject that the student had the high mark in ? as you can see ive tried Sub$ but i get the last subject read on file shown

the file is attached could some one have a quick look please

Thanks :D

NIC04058652,Ryan Nicholls,06/04/1986,English,45
NIC04058652,Ryan Nicholls,06/04/1986,IT,65
NIC04058652,Ryan Nicholls,06/04/1986,German,72
NIC04058652,Ryan Nicholls,06/04/1986,Maths,45
NIC04058652,Ryan Nicholls,06/04/1986,History,60
MOR04058653,Roger Morgan,8/11/1983,English,45
MOR04058653,Roger Morgan,8/11/1983,IT,54
MOR04058653,Roger Morgan,8/11/1983,German,11
MOR04058653,Roger Morgan,8/11/1983,Maths,86
MOR04058653,Roger Morgan,8/11/1983,History,66
WIL04058654,Ben Williams,11/07/1984,English,42
WIL04058654,Ben Williams,11/07/1984,IT,19
WIL04058654,Ben Williams,11/07/1984,German,77
WIL04058654,Ben Williams,11/07/1984,Maths,71
WIL04058654,Ben Williams,11/07/1984,History,33
BRI04058655,Clair Britton,28/09/1985,English,69
BRI04058655,Clair Britton,28/09/1985,IT,75
BRI04058655,Clair Britton,28/09/1985,German,80
BRI04058655,Clair Britton,28/09/1985,Maths,81
BRI04058655,Clair Britton,28/09/1985,History,62
MOR04058656,Mark Morris,22/02/1981,English,70
MOR04058656,Mark Morris,22/02/1981,IT,73
MOR04058656,Mark Morris,22/02/1981,German,89
MOR04058656,Mark Morris,22/02/1981,Maths,94
MOR04058656,Mark Morris,22/02/1981,History,66
  • 1 Contributor
  • 0 Replies
  • 72 Views
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.