Report question

[Guest]

I have a field in my table that is a lookup field with two choices "copies or
originals". When I set up a report with this field on it, how do I get the
report to show the text "Copies" or "originals" instead of the number 1 for
originals and the number 2 for copies. Anyone reading this would not know
what 1 or 2 meant. I am using Access 2003.

Thanks very much for any help.

Best regards,

Dee

 

[Duane Hookom]

Lookup field? Consider reading http://www.mvps.org/access/lookupfields.htm.
To change 1 to copies and 2 to Originals use:

=Choose([EvilLookupField], "Copies", "Originals")