Search results

I'm trying to design a query in which a sum is derived from a subquery which should select top 2 Currently this sometimes produces more than 2 where there are ties eg Select top 2 from (12, 10, 10 )... this produces all three so the sum is 32 instead of what I need... 22 Sample DB Kind Regards

Thanks SP. But I've been careful noit to use lookup fields. The naming is not a p[roblem, the data type is numbers and relates to the ID fields. Here I've attached the DB. Could someone helpme with a query on which to build the forms? I have here attached my expected reportcard for each student

Thanks a lot guys, and I think I should have been posting the DB instead of snapshots. Here it is

Hi, I've updated the structure of the database as per help in this forum. Could I hear your comment on the new structure? You could follow the main thread here: ....forums/showthread.php?t=257315 Thanks all, as we complete on the design and move on to queries, forms and completing the DB.

I have here posted the expected report for a level. You will note it also requires lettergrades which I think are not necessarily required in the relationships... could just be queried in relation to the marks scored by the student at the . Or is there a better way? I've also posted a snapshot...

Hi Solo, thanks for the reply. Earlier, I was advised against multiple paths between tables. Thus, will it be ok for the studentLevel table to not link directly to schoolyear? Level table already links to it. Thanks for your observation about Class, it applies also in some schools (multiple...

My understanding of the concept is still limited, but there's that Aha! moment that's close, or far. Playing around with the tables, I'm rethinking the relationships, more like I'm questioning than --expert. I'm in a four-year High School Kenyan system is 8-4-4 mine is thee middle four. A...

Thanks for the challenge, I took the question of a one path seriously and deleted some of the relationships that may not have been necessary. This has resulted in a more linear linkage. The Exams Results I'm talking about are what I've called StudentGrades Then, Each student is in a level and...

Yeah, It is as well a challenge I'm undertaking as I build the DB and learn. It is not a job I MUST complete. But I've been thinking about it for such a long time to warrant getting up to the challenge. For better understanding, I have those four classes (many) and Students (many) I therefore...

Thanks Xperts My concern comes from my lack of prior knowledge. I'm really wondering whether such data should be entered manually, computing the possible combinations. Thought it necessary to reply as I delve into further learning through your Tutorial. Thanks, I'll come back.

I get you Plog. I might have mixed up things a bit, but my Idea- about teacher-level is that There's one teacher in-charge of each level, and there's a teacher in charge of a subject area in a level. One teacher can only be incharge of one level, but can also be incharge of several subjects in...

:banghead:I have problems understanding lookup tables, especially how to populate them with data. I'm working on an exams database, and have many such tables... Table for Students Table for Subjects and a lookuptable for studentsubjects Table for Classes 1, 2, 3, 4 Table for Subjects Eng...

Dear Experts, I'm quite new to design of databases. With much reading about database designs, normalizations and seeking help here and there, I've designed the table described by the tables below. Class/level (LevelD, LevelName, SchoolYrID fk to tblSchoolYrs) SchoolYears (SchYrID, YrStart...