View Single Post
  #2  
Old June 7th, 2010, 03:27 PM posted to microsoft.public.access.queries
Twimm
external usenet poster
 
Posts: 2
Default Add character to string

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. Any help would be appreciated.