I am trying to help a friend make a database(and ultimately piece of none commercial software) to determine personality type as part of his thesis.
For the formula to work properly a couple of the questions need their values inverted(ie if the person answers 1 the recorded number will have to be 7 if 2 then 6 etc etc) he wants this to be automated.(or press button/macro/querey and it works it all out)
I'm guessing to do this i will have to set up a macro which reads the question number and then does some sort of IF loop(or else if) and then records the answers in a separate table.(along with other bits of data but i'm sure i can work that out)
Does this sound like the best way of handling this problem and if it is could i be shown the correct syntax for swapping a value of 1 with a value of 7.
I'm a bit stuck and any pointing in the right direction would be most useful, especially in regard to the swapping aspect as I can't find anything using google or my sQL/access book. Even the correct term for searching would be handy!