View Single Post
  #1  
Old June 7th, 2010, 03:06 PM posted to microsoft.public.access.queries
Marshall Barton
external usenet poster
 
Posts: 5,361
Default Add character to string

Twimm wrote:

I have a simple query that pulls data from a single table containing
some basic client information. One field is a text field containing
alpha-numeric data. For purposes of a report, I need to add the
letter C in front of these numbers. I do not want to update the
fields permanently, as there are other circumstances where I do not
want C to display. I tried "C"& ""&[CaseID], and variations thereof,
but none of them work. I know this must be simple, but I can't seem
to figure it out.


If the report is the thing that needs the C in front, the I
think you should add it by using an expression in the report
text box:
="C" & [the text field]

--
Marsh
MVP [MS Access]