This is what im trying 2 get
Sales Figures for 2006 in £000's
Sales staff name 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Max Min Total
John Smith 24 30 15 17 30 15 86
Joe Jones 24 19 10 20 24 10 73
Jill Evans 24 21 20 28 28 20 93
Quarterly totals 72 70 45 65
Total sales are £252,000
Star performers by quarters are:
Quarter 1 John Smith
Quarter 2 John Smith
Quarter 3 Jill Evans
Quarter 4 Jill Evans
i am haveing problems with displaying the star performers. I have got the code 2 display the correct value for the quarter, but the names do not work and are duplicated.
this is what i get:
Star performers by quarters are:
Quarters John Smith
Quarters Paul Evans correct
Quarters John Smith
Quarters John Smith correct
Quarters Jill Evans
Quarters Paul Evans
Quarters Steven Smith correct
Quarters John Smith
Quarters Joe Jones
Quarters Jill Evans correct
all help is welcome. thanx in advance.