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

  • Thread starter Thread starter sheepsrn
  • Start date Start date
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Excel print area which only prints pages of worksheet which are active 0
Print values of a listbox 2
Turning a 3 column flat file into a "3D" Table 2
Problems printing reports in 2003 MS Access 1
How do i get the value from a comboxbox and link it to print. 0
Multiple counts, same field, different values 8
Printing Report for one a single record - Several problems 5

Back
Top