By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,192 Members | 1,248 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,192 IT Pros & Developers. It's quick & easy.

Doing Data Conversions in a Form

P: 26
I donít know where this can be done put I think a form should be right. What I would like to do is add up several fields to get a total. I would normally do this in a query but there is one problem. Some of the data needs to be reversed. So A=3 B=4 C=2 D=4 I would add 3+4+2+4=13. But in some cases C needs to be reversed on a 7 point scale to a 6. So A=3 B=4 C=6 D=4 How can I do this?
Mar 20 '08 #1
Share this Question
Share on Google+
2 Replies


Expert 100+
P: 374
I donít know where this can be done put I think a form should be right. What I would like to do is add up several fields to get a total. I would normally do this in a query but there is one problem. Some of the data needs to be reversed. So A=3 B=4 C=2 D=4 I would add 3+4+2+4=13. But in some cases C needs to be reversed on a 7 point scale to a 6. So A=3 B=4 C=6 D=4 How can I do this?
Can you explain what you mean by a seven point scale in your example?

Not understanding what you're trying to do?

Email me back on this forum.

Joe P.
Mar 21 '08 #2

P: 26
Can you explain what you mean by a seven point scale in your example?

Not understanding what you're trying to do?

Email me back on this forum.

Joe P.
This form is a representation of a questionnaire and all the scales are from 1 to 7.

For example: how well do you sleep at night (choose one) 1 2 3 4 5 6 7.

Then each of the questions are added up to get a persons total sleep score.
But with some questions a high score would be need to be converted to a low score.

For example: Do you wakeup feeling sleepy (choose one) 1 2 3 4 5 6 7.

So in the first question a 3 would not be changed but if you get a 6 on the second question it needs to be converted to a 2. But in either case a 4 would be the same.
Thanx for the help
Mar 21 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.