I have a database with tons of fields and some of those fields need to be exported as a number, but there are a few types of number lists, such as

no = 0, yes = 1, unknown = 3

female = 0, male = 1

brown = 0, blue = 1, red = 2

Any ideas on how to make this easy for the users? I want them to be able to see the text value over the number value but for exporting to a statistics package, they need the number value.

Hi martha

setup a calc field (result number) for each field that has the options.

Use the case function to determine the result [ie Case(field1 = "no;0;field1 = "yes";2; field 1 = "unknown";3)].

Check the 'do not store, evaluate as necessary" box in each case and then export those calc fields

HTH

phil

Edited November 27, 200718 yr by Guest