Hi guys,
My question is the following:
- I have a hughe database of about 5 thousand records. It is for a research I'm doing. I have 5000 patients, 2500 are controls who received placeboand 2500 are the intervention group who received painmedication.
-I did measurement for both groups at t=3 and t=0 (0 means before start of the research and t=3 means 3 months after they got placebo or painmedication)
-I have one questions in this database: 1. Severity of pain (0-10)
My question is: what is the best way to calculate the differences for each person during t=3 en t=0? Should I make crosstab query to do this easily or should I do something else?
I'm kind of stuck here and I hope someone can help. So for example: Person X had had placebo medication and at t=0 he scored his pain with 10 and at t=3 he scored it with a 5, so I want to be able to calculate the difference easily with use of Access and Excel. In this case the difference is -5 (pain went from 10 to 5). How can I calculate this easiest? I really hope someone can help.
Thanks for reading,
Michael