Number Conversion

[Guest]

Hello,

I am trying to enter data from surveys. On the survey we are rated on a
scale of 1-5. I would like to enter the data as a 1,2,3,4,5. Then somehow I
would like to convert those numbers to thier point value.
1=0,2=25,3=50,4=75,5=100. Any suggestion on the best way to do this? I do not
want to enter the value 25,50,75 etc in order to save time on the entry end.
I have tried lining to a points value table but this does not seem to work as
I am link 10+ field to the one table. Can I do it in a query with some type
of IIF function. Thank you in advance Jason

 

[Joseph Meehan]

Hello,

I am trying to enter data from surveys. On the survey we are rated on
a scale of 1-5. I would like to enter the data as a 1,2,3,4,5. Then
somehow I would like to convert those numbers to thier point value.
1=0,2=25,3=50,4=75,5=100. Any suggestion on the best way to do this?
I do not want to enter the value 25,50,75 etc in order to save time
on the entry end. I have tried lining to a points value table but
this does not seem to work as I am link 10+ field to the one table.
Can I do it in a query with some type of IIF function. Thank you in
advance Jason

I would just enter them as you desire then use a formula to change them
to the point value when needed in a form, report or query. You also could
add a field to the table and use an update query to put the point value in
that field.

 

[PC Datasheet]

My!PointValue = (My!SurveyData - 1) * 25

 

[Guest]

Thank you so very much. It is such a simple thing that I wounder why i didn't
think of it. Thanks a million. Jay

 

[StopThisAdvertising]

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1100 users have come to me from the newsgroups requesting help
(e-mail address removed)

--
To Steve:
Over 300 users from the newsgroups have visited the website to read what kind of a 'resource' you are...

To the original poster:

Most people here have a common belief that the newsgroups are for *free exchange of information*.
But Steve is a notorious job hunter in these groups, always trying to sell his services.

Before you intend to do business with him look at:
http://home.tiscali.nl/arracom/whoissteve.html (updated)

Arno R

 

[OldManAccess]

Jason,
If you have time, look into using a Pivot Table for this analysis. In
a pivot table, the question is the row, the response the column, and
the count of response the value. This way, the data is simple row
information with question and repsonse field and the pivot table
outputs the results. A corresponding Pivot Chart provides graphical
interpretation.