I have an MS Access Database that I would like to interrogate using VBSCRIPT ASP. The project is for an online school assessment tracking database. I am a school teacher.
I anticipate colleagues being able to select the table (one for each year group) they want to interrogate, choose a field name (e.g. music) and then choose which class they want to work on (e.g 7M2). They will have student name and target data displayed as well as input boxes for Teacher Assessment data.
I have all the code necessary to upload multiple non-sequential records and I can do any INNER JOIN should I want to separate timetabling and assessment data.
My problem is two FROM clauses that refuse to work. The entire project is written up as far as I have got with two ASP pages and a test database. It is all available by e-mail on request.
I've been informed that it shouldn't take more than 1-2 hours for anyone who reads VBSCRIPT to sort this out.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).
3) any materials recieved from me remain exclusively my copyright and may not be divulged to third parties
Win 2K IIS; Win XP IIS