can i save one value in a table but print a different value in a .

S

sheepsrn

i want to save a value such as "wnl" in a table but print out a meaning in a
report for example " well developed, well nourished in no distress" to
decrease the amount of data stored for each patient.

Access 2007
 
M

mray29

One solution is to create a lookup table with an ID field and a text field.
Store the long text strings in this table, but only store the ID in the
original table. Then use a query to produce the data by linking the two
tables.
 
Top