Replies

sweet thanks, that basically worked. had to do some rigging to get it to update to the tblgrade (kept saying must use updateable query so i appened it to a new table called tablegetgrade then i just used that table to udpate tblgrade, worked fine sorta)

thanks for help everyone, that worked good.

(Edited by WendellB on 01-Apr-03 05:42. activate linke to web page)

i drew up a quick picture of it. go to 1 then to 2 then to 3 to understand it a bit better.

http://24.78.165.11/pic/accessrelationship.JPG%5B/url%5D

ya i got update query now for it which kinda makes it lame. I think i gota think of another way to do this. and t1 isnt one to many t3.

table3 will be holding a value that keeps getting added to.

im thinking i gota throw some vb in here somewhere. and no its not an assignment, its a project. actually ill go more into detail about it.

its a student database which lets teachers add student grades for certain assignments, etc

basically the table1 they enter a student and score on the assignment they got and a assignment “code”. This code is stored in table 2 which holds how much the assignment is worth and also how much the assignment was out of. Thats where the caculation comes in. I gota divide the grade they got on the assignment by the total value of the assignment then multiple it by the percent the assignment is worth. Once thats done it gets ADDED onto the field in table 3 which holds the total grade for a student in a certain class. so basically teh students start at 0 and work there way up to 100.

im 100% sure i need it stored unless there is another way to do it which im not thinking of. Basicly its like this.

table2 has a one to many to table1 and table 1 has one to many to table3
(table1.value / table2.totalvalue) * table2.PercentOfTotalValue = answer
then
answers + table3.total = table3.total

basically there is a bunch of values added up to make up to 100%

Thanks guys. I was on a one track mind there, lol. Now gota make me somthing for it to refresh it everytime i run my report.

nevermind found out how, for future reference…
hidden table named mysysobjects
pulled the name from it
then did a like tbl* for critrea

thank you so much charlotte. That last post fixed ALL my problems!
<3 charlotte!

charlotte you lost me.

each field is setup in the one said as unquie. But i doesnt work. What i dont understand is if i do one at a time it works just fine but more than one at a time and it wont do it.