Recent content by NeilT

it works but would end up massive as every pupil would have a line, where as in the manual ones we do at the moment the most lines is about 8 or 9, which is children on the same level. Thanks again

Brian that is brilliant thanks so much!!! Is there anyway to remove blank entries? Thanks for everyones time and help really appreciate it!!

Thanks so much for all your help!! Neil

yea i did that but it just gives me my table i originally started with only ordered differently. I beginning to think maybe it isnt possible to do what im asking. thanks for the help

george has edited his post. i still get an error though.... SELECT name, Levels, Subject FROM Pupil_Results WHERE ((Pupil_Results.Subject)="Maths") GROUP BY Levels,name; It errors saying i havent grouped by subject but have selected it.

I get an error on that George cannot group on fields selected with * im trying to get 3c 3b 3a Joe Sarah Polly Neil Thanks Neil

Ok thanks ive read up on 1nf and tried to apply it to my data its going to get more complicated but thought id try and get it working on a simple version. My table now reads Pupil_Results Name Subject Levels Joe Maths 3c Neil Maths 3c Polly Maths...

Thanks for the posts!! I dont want to store the data twice i just need to display the results in those coloumns, there are around 25-30 possible marks(levels) which are split into coloured bands and showing it like that would allow us to get a good overall spread of the class. excuse my...

Hi I am tying to create a databse for our school which tracks the pupils results. I have a table (pupils_results) which stores their various results.... Name Reading Writing Maths Neil 3a 3b 3b Joe 3b...