Concatenating Fields

[Jack Houck]

Hello,

I'm having problems with an attempt at concatenating fields
in a query.

I have data coming from a link (questions with answers)
that is split up into their respective components: q01,
q02, q03, etc...

I have Question 5 (q05) split up like this: q05a:
Mid([q05],1,2). Basically there are several "splits" for
q05 into the before mention q05a, q05b, etc...into their
own fields.

I want to add a field the concatenates these into one field
again (so that I can pick and choose which go into the
field). For instance, one of the fields I need to create
would include q05a through q05e.

Any ideas how this can be accomplished?

Thank you in advance.
Jack

 

[[MVP] S.Clark]

The ampersand is used for concatenating.

a & b = ab

Now, the value of 'a' could be from text, a date, a number, or other data,
but Access knows that a string is the resultant datatype.

thus if a = "p" and b = #12/12/2004# then ab = "p12/12/2004"

So,
your's would need to be
q05a & q05b & q05c & q05d & q05e
for whatever values these hold.