Checking for right answers

[gug]

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

[Slobey]

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.