At 07:50 PM 06/11/2006, Brian Weeden wrote:
It's been a long while since I did any work with Access and I ran
across a problem today. I have a database where the end column is an
alphanumeric code. I want to generate a report that substitutes in a
certain value in the report instead of the actual DB value without
changing the value. For example, if the DB shows A1 I want it to show
Jan and if A2 Feb.
I'd do as Bobby said and create a second table with two fields:
MonthID Month Name
A1 Jan
A2 Feb
etc etc
Then I'd create a relationship and pull the data across that way.
T