Search results

Thanks a lot I got benefit from the application of the query Regards

Thanks a lot Mr. Arnelgp I thinks it is difficult to deal with thousands of records in "Marks table" in this way. I appreciate your advice.

Thank a lot for your efforts. You mean I can not loop through these recordset to find topics with less than 50 and to insert them in a new field in the way I mentioned?

I apologize dear and This is the structure of tables

thanks I divide the work into 2 tables one containing the marks and the other the Fail topics the needed code is to insert the results for each student as creation of a new table or updating a field in an existed table regards

is this valuable?

I have a table named "Marks" contains marks for several topics for each student. I need a code to insert the topics with marks less than 50 in a filled named "fail_topics" corresponding to each student. I appreciate your support :)