Recent content by Darwin

You're right not Charles, not even Darwin. It's Luke. This does sound far more complex than I am able to tackle with my existing access rights to SEEMIS, so I will stick with the manual movement to and then import from Excel. I had thought I was pretty good at this, but on looking back I...

Hi again, Firstly I can confirm that the query you created does indeed work as intended now that I have tested it in school on real life data. I'll need to reply one more time after this, then my post count will be high enough to view the links in your signature. :-D I do already import the...

Thank you Ridders. You have made it do exactly what I was trying to get it to do. You even read my mind and excluded the irrelevant arrangements, although I do actually need to put TBC back, as seeing that in the resulting report is the flag to chase up pupils/staff/parents who haven't provided...

Hi, I developed this database about 4 years ago, and it's safe to say that it wouldn't be where it is without help previously received here. It is used to organise the support provided in exams to pupils with additional support needs. I have attached a zip of the front and back end to help...

Just to let you all know I fixed this in the end. It seems I just needed to rebuild my queries from scratch to solve the outer joins errors. Looking at the properties of the original query which I modified to take account of new structures, and the completely new new query showed them to be...

P.S. By all means please tell me if you think I have got normalisation all wrong. I tried both working from a decomposition point of view, but also from an entity relationship point of view. Both made my head hurt.

OK, I've read up those suggested links on normalisation and a bunch of others as well. :) Now as far as I can tell my tables were almost normalised I just needed some tweaks. I now have tbl-PupilDetails -ScottishCandidateNumber primary key (Unique number which identifies pupils to the...

Thanks I think? :confused: How would I set up that table? And how would I relate it to the subjects? I already use lookup tables for subject, level and arrangement, would I need/be able to incorporate the faculty information into the subject lookup. I tried this previously, but got myself...

I think this is a table question, if not please feel free to berate me and move it to the right place, I also think the question has been covered before, but any of the searches I try don't quite give a solution to my issue. (At least not one I can understand.:confused:) I'm trying to complete...

Hi All, I'm a Science teacher in Scotland, with the responsibility for organising additional exam arrangements for pupils with additional needs in a secondary school. When I took this role on, it had for many years been done with paper and pencil, and although a complete Access and database...