Inputing numbers but displaying text on reports

[Guest]

I would like to use numbers for input on forms to speed up data entry, for
instance:

1- positive
2- negative
3- already assigned
9- incomplete

But would like the text (rather than the number) displayed when I create
reports based on the field in question.

I am using combo/list boxes for the input and lookup tables for the values.

Can this be accomplished?

 

[Guest]

1. Create a table with two fields: ID (number type) , Description (text)
2. The table should contain the values you indicated in your post
3. In the Report RecordSource link the table you created in stage 1 to the
main table, linked by the ID, and add the Description to the record source

 

[eos]

AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George

 

[eos]

AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George