Search results

Me again! This time I'm striding out WAY past my ability level, and was looking for someone to help me solve the problem, and help me learn! Having rootled through the internet I think I need to build a dynamic query to get what I want, but if there's a simple way, I'd be even more grateful...

Help! I'm beginning to wonder about my sanity! I am trying to find an overall average of point scores given to a class for a certain subject, during a certain assessment period. I have created a query using 2 tables; TblYearData contains information about a given child in a given school...

Again, I feel I'm missing something obvious! I'm making a school database. Each child has a record with their basic details (Forname, Surname, DOB, gender) in tblChild, and a record for each year they are with us containing extra information (which may be different year on year such as SEN...

I'm sure there is a very simple answer to this which I am missing - I've had a rootle but haven't found anything similar on the forums. On my form I have a text box called [YearBeg] into which the user enters the year in which the school year begins - ie. "09". From this, in a calculation field...

Right, I've been bouncing this around in various parts of this forum, and I'm stumped. Still. I have 2 tables - tblChild, and tblGrades. The child table stores all the details about the child - surname, forname, gender etc. The Grades table stores grades given in 5 areas - Reading, writing...

Hello! I'm currently working on a a form which displays student's names with grades given at various times over the year. I want to populate a field within the grades table with the difference between the most current assessment and the previous assessment. I appreciate that this is not...

Hi, I have created a number of combo boxes from which the user picks a number of different things (obviously), for example the year, the class, and the subject. Because I am creating this database to be PAINFULLY simple for the user, I would like to be able to display (above the button which...

Hi, I am creating a database for a school. I have each child's details in a table called 'tblChild', and each child's grade in a table called 'tblGrade'. As I am trying to track the child's progress through the school, the grade table contains a year column. As the database is updated each...

This seems to be a fairly simple thing to do, but I can't for the life of me get it to work! I have an option group containing 5 options - Reading, writing, numeracy, science, speaking and listening. Based on the choice made by the user, I'd like to open one of 5 different forms - fReading...

Hi, I've read everywhere while searching for solutions that the Golden rule of access is to calculate anything which can be calculated rather that storing it. However, for various reasons the data does need to be stored. So here's what I'm after. The database is for a primary school, and...

Hi, I've been having a butchers, but couldn't find any solution to my problem - apologies if I've missed an answer somewhere - please link me! My database is sorted and I'm looking to make it more attractive. I know it's only superficial, but the buttons on access look really boring. I'd...

Hi all, This is my first post, so please bear with me if I forget something out which you need to help me! I'm creating a database for my school to monitor pupils progress. All of the information I need for this problem is in one table. I want to be able to show overviews of children...