Access query

  • Thread starter Thread starter Judy
  • Start date Start date
J

Judy

I want to join two or more text fields into one field.
When I run my query I'm only getting the first field and
not others. This is what I tried. Expr1:[des1]+[des2] and
I tried Expr1:[Des1]&[des2]

What am I doing wrong?

Thanks
 
Judy,

Expr1: [Des1] & [des2]
.... would appear to be the correct expression. Do you mean that when
you try this, the query only returns the data from the Des1 field in the
Expr1 column, and the data from the des2 field is not shown at all, in
any records?
 
Yes, that is eactly what happens. I have more than 3
fields that I want to combine and I have tried it with 2 &
3 and then with 3 & 4. Each time I only get the first
field data no matter which field is first.

thanks, Judy
-----Original Message-----
Judy,

Expr1: [Des1] & [des2]
.... would appear to be the correct expression. Do you mean that when
you try this, the query only returns the data from the Des1 field in the
Expr1 column, and the data from the des2 field is not shown at all, in
any records?

--
Steve Schapel, Microsoft Access MVP
I want to join two or more text fields into one field.
When I run my query I'm only getting the first field and
not others. This is what I tried. Expr1:[des1]+[des2] and
I tried Expr1:[Des1]&[des2]

What am I doing wrong?

Thanks
Click to expand...
.
Click to expand...
 
Judy,

Just a shot in the dark here... Is it possible that there is a
"carriage return" at the end of the text in each field, so when you view
the results of the query the second field's data is still there, but on
a second line, so you wouldn't see it unless you expand the height of
the query row or form control?
 
Back
Top