September 11, 200520 yr hello I have a db with a large list of mutiple choice questions for school, i have another field on a seperate layout that shows the answers. when you complete the test is sends you to a layout showing your answers and the actual answers. is there anyway to auto correct then answers and display if it's wrong or right in another field. I was thinking this had something to do with the case fuction Thanx in advance
September 12, 200520 yr If you want a separate field for right or wrong, then yes a case statement would work fine. case(test field = answer field;"correct"; incorrect) Not knowing the structure of your DB, this calc assumes the answers are in the same record or there is a relationship between them.
Create an account or sign in to comment