Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Other Forums  MS Access  Comparing records

Author  Topic  wislace Starting Member 1 Post Posted - 2008-06-06 : 12:49:26 Pls i need someone to help me out.I have two access tables namely tblGrade tblScore Now the tblGrade table consist of id,aggregate the aggregate is made up of 1-10%=1st 11-20%=2nd 21-30%=3rd 31-40%=4th and others whiles the tblScore table consist of stName stClass stScorce staggregate i will like a situation whereby the score of a student for example if a student score 35 percent he will fall under the 4th.How do i create that. am using dreamweaver 8