Recent content by Reppers

Mr B! That's one of the sites I looked at previously - the one that led me to believe that building a dynamic query is the right way to go. The problem is, I have no real experience using VBA or writing SQL statements - everything I've done so far is cobbled together from bits of code I've...

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...

Cancel that - problem solved! I've looked at this all day, and then 5 minutes after posting for help, I solve it myself - blooming typical. The query was struggling with averaging the field with the subquery. I'm not sure why, I don't have the energy to find out now. I split the subquery to...

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...

Cheers for all the help guys - although I must admit (ashamedly) that there was an extremely simple solution to my problem! Ultimately it was solved by using as simple append query - Initially finding all the previous year's data (08/09) and appending every field to a new record, except the...

Sorry to be a pain, but is there any chance of you walking me through the solution in baby steps? Here are the details of the table; tblYearData contains the fields; YearDatatID ClassID ChildID SchoolYear SENID ReadingRecovery LookedAfter SeriousCVA FreeMeals ELS Wave3 Quest So, I need to...

Thanks RG, I'm with you - the fault is with my inaccurate description of what I want to do - sorry. 250 or so new records will be created in tblYearData at the start of the year. A good number of the records will remain exactly the same for whole year. Records would be updates over the year...

Cheers for the reply RG - apologies if I'm misreading, but doesn't that just apply if I'm updating the records through a form? I'm after a query which will add a new record to tblYearData for each child currently on roll in tblChild using that child's previous record in tblYearData for all the...

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...

*Bangs head on wall* Cheers Brian, I think it may be time to give up for today!

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...

You Sir, are a scholar and a gentleman! It has fixed the problem! However, having been forced to contemplate the potential complete collapse of the whole database, and now having come on somewhat in my access-ing abilities, I do see the point in normalisation. However, this botch job will do...

I do appreciate that - and if this problem does stem from the lack of normalisation then I acknowledge I may have to start from scratch. I put that sentence in really to make it known that I was aware of the lack of normalisation - I am a novice, and had I known I'd reach this stage and then get...

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...

I did try that, and it does update one of the rows. The issue is that the runquery button is sitting in the detail section of the continuous form, and each button only updates its row - so to update each row, I need to manually click 30+ buttons. I was looking for a work around which would say...