Please help

[titch89]

Don't no where to really put this so i thought i put it ere.


Just wondered what way would be the best to do this.

I got 1 tbl which has questions in it and the user goes in and has to answer them on a form. I have another table which has the answrs. Wen they answer the questions on the form i got a query which runs to see whether they are right or not.

What i need help with is whther i can have some sort of thing which can calculate how many they got right and show it on the screen. Something like if they right then a tick comes up and not then a cross.

Pls help

 

[rainman89]

add something like

Dim numright as int
Dim numwrong as int

if(answer is right)
numright=numright+1
else
numwrong=numwrong+1
end if
something like that

then ud have to have a txt box on your form that updates to these numbers.
adding the checks and stuff is beyond me though

 

[titch89]

k ty m8 dont matter bout the ticks as they not as important


Tried to input the code but it dont like the start of it and it dont work. Where exaclty do i put the code into cos i may be puttin in into wrong code bit. i quite experiance in Access but the code bit confuses me sometimes

Pls Help

 

[rainman89]

do you run your query through a button to see if they are right or wrong? or how do u do it?

 

[vangogh228]

What does "k ty m8" mean???

 

[rainman89]

k thank you mate>??
not a normal expression here in the states

 

[titch89]

well i got the answers on the form and then i press a button which runs a query

 

[The_Doc_Man]

Search the forum for topic "Questionnaire" which has been visited several times. The forum search button works OK if you know the topic.