'i am thankfull to all those people who said NO..Becouse of them..I Did it my self'
~Albert.Einstei n.~
sashasandy
Last Activity: Sep 19 '13, 07:30 AM
Joined: Aug 30 '13
Location:
-
haha! av got to say, zmbd. You are making it seem like a National Disaster!...anyway am still on the primary stages of developing this database, YES- i am typically converting a Flatfile "excel-based" database to a Relational Database. YES i was going to use UNION queries and Action Queries for most of the Work in this database, and Frankly am not Banging my head at 100MPH...haha!i think so far AS PER what i want the database to do,Its...Leave a comment:
-
thanks Seth, I have posted the whole design in the below links for a clear picture of what i mean.
the part with most concern is:relationship PartB
relationship PartB-
[imgnothumb]http://bytes.com/attachment.php? attachmentid=71 90[/imgnothumb]
relationship PartA-
[imgnothumb]http://bytes.com/attachment.php? attachmentid=71 91[/imgnothumb]
[z{second post- inserted images above}]...Last edited by zmbd; Sep 9 '13, 02:44 PM. Reason: [z{merged posts with the correct image links}{placed inline}]Leave a comment:
-
Table relationship/Design problem
i have 6 tables
-tblStudents_inf o( includes students names,address.. etc)
-tblStudent_Clas ses(includes students classes and streams)
-tblStudent_Subj ects(includes students subjets based on a certain combination.)
-tblStudent_Mark s(includes student marks in various subjects)
-tblExam_Name(in cludes examID,Exam_Nam e)
-tblExam_Period( inclues PeriodID,Period _Name)
problem comes in how do i relate... -
zmbd, thanks for the concern, the database i used is only for demonstration purposes, instead of posting the entire thing i decided to break it down to something small and understandable.
any way. For future readers this query Calculates the GRADE,GPA and shows COMMENTS all per subject, and also the The Total and Average:
Cheers.
SQL:
...Code:SELECT SM.Student_ID, SM.Students, SM.class, SM.Maths, SM.English, SM.Science, (SELECT
Leave a comment:
-
found 1 alternative method: but would like this one (using the SQL in the question) to work.
Alternative solution:
...Code:SELECT SM.Student_ID, SM.Students, SM.TotalAverage, SM.Maths, SM.English, SM.Science, ( SELECT GD.Grade FROM tblGrades AS GD WHERE GD.MinMarks = ( SELECT TOP 1 GD.MinMarks FROM tblGrades AS GD WHERE GD.MinMarks <= SM.TotalAverage ORDER BYLeave a comment:
-
Query to calculate Grade using Lookup and innerjoins.
I have a database with:
2 tables, tblStudentMarks and tblGrades
2 Queries qryResults and qryStudents_Gra des
[z{struck image... giving error}]
1.qryResults:Ca lculates the TotalAverage:(M aths+English+Sc ience)/3.
2.qryStudents_G rades:Calculate s the students grades based on the TotalAverage by comparing the total average to the min & max marks on the tblGrades.
Grades are compared...Last edited by zmbd; Sep 7 '13, 07:27 AM. Reason: [z{struck image... giving error}{stepped SQL for easier reading}] -
Seth! Am so sorry i dint see this thread, i thought no one bothered.But thank you very much....am going to try your method right away.. although i posted it here also: http://goo.gl/spthFy.
I also got a solution using a complex subquery. quite similar with your idea of making a table first.
Well, The challenge with the method i found is: I can only compare one value at a time. that is in this case "Marks". I would also like...Leave a comment:
-
wow! am surprised its very simple, i was thinking deeper than i should...its actually is a simple relationship that works the trick, i created a relationship from tblStudents_Mar ks to tblfees and joined the fields FeeStructure_ID which is in both tables.Then the query automatically picks the correct fees in reference to students fee structure(which are more than 5 fees structure records, like STR1,STR2,STR3. .etc) and calculates the balance.
...Leave a comment:
-
Query to calculate Balance based on Different Records in another table
I have a database with two tables.
1.tblFee_Struct ure.
2.tblStudent_fe es.
tblstudent_fees contains the fields: student_ID,Stud ent_name,Struct ure_ID and fee_paid.
In this case the fields we are concerned about are "Fee_Paid & Structure_ID"
tblFee_Structur e contains two fields: Structure_ID and School_Fees.
-this table has more than 2 records i.e, more than 1 fee structure.... -
using a query instead of vba function.
hehe!! i guess it has had u in surprise also, because it does!
i used a query instead of vba.
see attachment below for any one who might bump into this.
this Thread is SOLVED!
:-)...Leave a comment:
-
thanks, surprisingly i have found the solution!!
by using lookup in a simple query.Leave a comment:
-
Edit conditional statements in vba via form.
Hi i have this code:
i want to make it available for user to change/edit the values i.e(marks range and grade) in a form. is it possible?
...Code:Public Function ValGrade(PrMark As Double) As String Select Case PrMark Case 80 To 100 ValGrade = "A" Case 75 To 80 ValGrade = "A-" Case 70 To 74 ValGrade = "B+" Case 65 To 69 ValGrade = "B"
-
How to Customize an IF Function in vba using a form
hallo experts!
i would like to customize an if function in vba,
that is allow the user to change the condition, value if true and value if false all in a form.
how would i achieve this please!!!
...Code:Grade: IIf([Marks]>=80, "A", _ IIf([Marks]>=75,"A-", _ IIf([Marks]>=70,"B+", _ IIf([Marks]>=65,"B", _ IIf([Marks]>=60,"B-",Last edited by zmbd; Sep 2 '13, 04:42 PM. Reason: [Z{add required code formating (Please use the [CODE/] button}{Even though not VBA style, Stepped the code as if VBA for better logic flow and easier reading - WILL NOT WORK AS A CALCULTED FIELD this
No activity results to display
Leave a comment: