T
Twimm
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.
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.