Brian, My first inclination would be to build a lookup table that has the value and its related value and then link to that table in your query.
SomeTable OldValue NewValue A1 January A2 February ... The other thing you could do would be to use the switch statement, either on the report or in the query: =Switch(FieldName="A1","January",FieldName="A2","February",...) I think the 1st option is the most appropriate here. As for the sum part, I am not clear on exactly what you are wanting. Are you saying? A1 A1 A3 A2 A1 A3 count of a1=3 count of a2=1 count of a3=2 If so, I am not sure how to do that. Bobby -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Weeden Sent: Monday, November 06, 2006 6:51 PM To: hwg Subject: [SPAM SUSPECT] [H] MS Access question Importance: Low 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 would also like the report to do counts for me, like if A1 appears 6 times in a column to display the total number. I know it is possible but can't quite figure it out. -- Brian
