To convert entered text

[alan83_in]

how to write a macro that can access my table

hi,
I want to store the entered data as numbers for calculating frequencies. Can anyone help me write a macro that will check for entered text and store the appropriate value.
For exaple, there are 5 salary ranges
<$20,000
$20,000-$30,000
$30,000-$40,000
$40,000-$50,000

I display these values in a combo box for the user to select any of them. I want to store the selected value as numbers in my table
like:
<$20,000 1
$20,000-$30,000 2
$30,000-$40,000 3
$40,000-$50,000 4

I.E.. AS 1,2,3,AND 4 so that later i can transfer these values into SPSS and calculate frequencies. Kindly help me to do this.
Thanks much.
Allen Sylvester

 

[mdemarte]

salary table

I would suggest a table. One field is the numeric code that you want, the other is the salary range as a text field. Then, as you select the value you want, store the numeric value. Use the table as the source for the combo box. BTW: Would your 5th salary range be >$50,000?