Hi,
I can't get to the solution of my problem.
I have a database with a table "Intrebari" (contains N questions, answers, correct answer) and a temp table "tblTest" (contains questions M questions randomly generated from "Intrebari", and remember your ANSWERED OPTION).
The DB also has a form "Test" (the quiz) which shows each question from "tblTest" and 3 choices of answering.
The query "Test Scoring" verify if my answered option stored in tblTest is the same with the correct one and set the value "1" for True or "0" for not in that query.
Well done until now. What I can't get to is that I want to show instantly (live update) in the form "Test", remaining questions from M selected in "TestSetup" form, correct answers, wrong answers. If wrong answers reaches 5 (>4) the form closes, or execute a command.
I can't use SUM function in VisualBasic
I can't get to the solution of my problem.
I have a database with a table "Intrebari" (contains N questions, answers, correct answer) and a temp table "tblTest" (contains questions M questions randomly generated from "Intrebari", and remember your ANSWERED OPTION).
The DB also has a form "Test" (the quiz) which shows each question from "tblTest" and 3 choices of answering.
The query "Test Scoring" verify if my answered option stored in tblTest is the same with the correct one and set the value "1" for True or "0" for not in that query.
Well done until now. What I can't get to is that I want to show instantly (live update) in the form "Test", remaining questions from M selected in "TestSetup" form, correct answers, wrong answers. If wrong answers reaches 5 (>4) the form closes, or execute a command.
I can't use SUM function in VisualBasic
