That's what I did to solve the first problem. Thanks guys.
On 11/7/06, Thane Sherrington <[EMAIL PROTECTED]> wrote:
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
-- Brian
