Field Lookup

  • Thread starter Thread starter Bill J.
  • Start date Start date
B

Bill J.

How do I have text in a field like 12345 = ABCDE when it
is output to a report In other words if a field in a
table has 12345 in it I would like it to print out ABCDE
in a report. these will not change 12345 will always =
ABCDE and so on
Bill
 
How do I have text in a field like 12345 = ABCDE when it
is output to a report In other words if a field in a
table has 12345 in it I would like it to print out ABCDE
in a report. these will not change 12345 will always =
ABCDE and so on
Bill
Click to expand...

Have another table (a "lookup table" if you will), containing the
translation from 12345 to ABCDE, from 54321 to VWXYZ and so on.

Base your Report on a query joining the field in your table containing
12345 to this table; select the text value from the lookup table for
your report.

One suggestion: by all means use the lookup table, but I'd suggest
that you should not use the "lookup field" type in table design. It's
badly designed and very misleading - see
http://www.mvps.org/access/lookupfields.html for a critique.
 
Bill,

From your posting it is not very clear to me exactly what you are trying to
do. Which is the case:

(A) replacement of each digit in the field value with a letter, so digit 1
becomes A, 2 becomes B etc, and the field value could be ANY number, or
(B) one-to-one replacement of a given set of numerical values with
predefined text strings

Nikos
 
Back
Top